Date field as Text when exporting to Excel

[aramirez]

Greetings,

Background: I am attempting to export a report with date time fields as date format into excel. When the report is exported into Excel, my fields display as a string and not date field. The user would have to perform an extra step and use the excel function for 'Text to Columns' to convert the columns to a date. I have tried the following formats below along with using the expression in the report to convert to date but my fields still export as a string. I have also made sure that the 'Text Format" in the properties is set to 'Date'.

CONVERT(varchar, mydate, 101) AS 'MyDate',
CONVERT(VARCHAR,mydate,101) AS 'MyDate',
CAST(mydate AS DATE) AS 'MyDate',

Question: How would I be able to export the fields as a "date" format to my report in Excel?

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.