Date Format Error in Web intelligence Report

[Former Member]

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.

[Former Member]

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

[Former Member]

hi sat p

Thanks for your reply but now my problem is solved.

Regards,

viral,

[sat_p2]

HI,

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

Regards,

satya.