Skip to Content
Apr 25, 2012 at 10:51 AM

Problem with Date field in Exel (BEx Analyzer).


Dear experts,

I am facing the following issue with date field when viewed in Analyzer(Exel) .

If the date begin with 1 or 2 or 3 then the date is displayed perfectly but when it starts with 0 it is displaying wrong values .

To be more clear if the date is 11-05-2010 or 21-05-2010 or 31-05-2010 it is displayed properly but when the date is 02-05-2010 then it is displayed as 05-02-10 ie the date and month are interchanged and only last two digits of year is displayed . But when this report is run on Portal the values are perfect and even in the cube the values are perfect .

Any idea how to rectify this error ?

Thanks and Regards .