Incorrect date format when exporting to Excel

[jsstern]

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?

[former_member203168]

Hi Julie,

Use totext function instead of date field. Probably something like this,

totext({timefield},"dd/MM/yyyy").

Date field export to .CSV format | SCN

check above link for more information.

--Praveen Guntuka