Hi All,

We have a Date field showing format in MMDDYYY, after exporting the report to .CSV format date field is showing correctly.
we have changed the Date format to DDMMYYYY, after exporting the report to .CSV format some of the date fields are converted to General datatype and some of the date fields are showing Date datatype in MS Excel.
My datasource is SAP Tables, I have replicated the issue with using SAP BW Query also.
To replicate the issue at your end, create a report with a Date field and change the Date Order to DMY
and export the report to .CSV format and check the fileds allignment and data type.

Is this bug in Crystal Report?

i have converted the Date field to string using
" " + ToText({Date Field},"dd/MM/yyyy")

But I want to show the date fields data type as it is in .CSV format.

Do we have any solution for this?