Skip to Content
0
May 16, 2016 at 12:38 PM

Incorrect date format when exporting to Excel

904 Views

Our reports are generated using Crystal Report 2008 Viewer, and can then be exported from there to Excel. However, our customers in regions where their date setting is DDMMYYYY are reporting problems with their dates when exporting the report to Excel. If the DDMMYYYY date is not a valid date in MMDDYYYY format (e.g. 31/03/2016 as March 31) then it appears correctly as 31/03/2016 in Excel. However, if it is also valid as MMDDYYYY (e.g. 01/03/2016 for March 1) then it appears in MMDDYYYY format as 03/01/2016 in Excel. This is only when exporting to Excel -- if the report is printed to screen, to the printer, to a PDF file, then the dates are correct.

All of the dates in our Crystal reports are formatted as Windows Default Short Format.

Any ideas?