Date field as Text when exporting to Excel
Posted: Fri Oct 12, 2018 6:13 pm
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?
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?