Support Article
Date format value in report displays as string in excel
SA-45243
Summary
In report definition, Date format column value displays as a string value when exported to excel.
Error Messages
Not Applicable
Steps to Reproduce
- Create a report definition with DateTime column (such as, pxCreateDateTime)
- Add custom format date, yyyy-mm-dd in report definition column options
- Run the report and export the results to excel
- Open excel and filter the above column
Root Cause
The issue is with Pega Export to Excel logic. For DateTime columns, the export logic informs excel to expect a date format with time for all the column values, also when the DateTime column is configured with custom Date format. In such cases, excel fails to parse the data and hence treats those values as string.
Resolution
Apply HFix-37711
Published February 13, 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.