Support Article
Different dates display in report definition and exported Excel
SA-45220
Summary
Different dates display in the report definition and the exported Excel.
Report Definition:
Report:
Excel File:
Error Messages
Not Applicable
Steps to Reproduce
Export the report to Excel.
Root Cause
An issue in the custom application code or rules.
The report definition column options for the DateTime columns specified a 'Date' Column format. This is not a valid property of DateTime type.
Resolution
Perform the following local-change:
- Specify a Column format of 'Date Time' in the 'Edit column options' menu.
- Set the Date only format on the Format popup (click the magnifying glass icon).
Published April 15, 2018 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.