Skip to Content
avatar image
Former Member

Date Format Error in Web intelligence Report

I created Web intelligence report using the BEx query.

The problem is when i drop the date field in webi report it gives me only one date that is (01/01/1970)

but the year and month field that are calculated on BEx query is coming in correct way.

So any one have solution to this Bug.

I m currently on :SAP BO 4.0 SP 2

SAP BI 7.0 EPH 2 on NW 7.02 Instance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Sep 11, 2014 at 09:38 AM


    HI,

    Not getting whatever you are trying check...please give few more example where you are facing error.

    Regards,

    satya.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 16, 2014 at 05:11 AM

    hi sat p

    Thanks for your reply but now my problem is solved.

    Regards,

    viral,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 17, 2014 at 08:16 AM

    Just check the values in BEx report. See if you are limiting your report to display only those records for which date is 01/01/1970. If not, then try changing the date format in Webi report.

    Rgds..

    Shambhu

    Add comment
    10|10000 characters needed characters exceeded