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?
Date field as Text when exporting to Excel
-
- Posts: 6247
- Joined: Tue Mar 20, 2018 5:34 am
Re: Date field as Text when exporting to Excel
Hello,
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.
Please send us a sample report with test data which reproduces the issue for analysis.
Thank you.