Skip to Content
1
Former Member
Apr 27, 2009 at 04:56 PM

Incorrect date format in excel reports

1755 Views

Hi,

Some Activity exported from Activity overview to excel have wrong date format. For example

Some have 21/04/2008 u2013 Correct

Some have 13/04/09 u2013 Incorrect

All the dateu2019s in the database seems to be correct like '2008-04-13 00:00:00.000'.

Client is using SAP B1 2005 SP01 PL-48. Is there any know issue?

I tried the same in B1 2007 upgrading the database. All the date seems to be correct when I export it here.

What may be the reason?

Any suggestions will be appreciated.

Regards,

Mohan