Support Article
Inconsistent date value format
SA-68914
Summary
When exporting a report definition with a date property to an Excel file, the date value format is inconsistent in the date property column.
Error Messages
Not Applicable
Steps to Reproduce
- Open the report definition rule
- Export the rule to Excel
Root Cause
Excel is linked to the Pega application with the English-US time format. Excel misinterprets values from the application when the time format of the system (English-US) is set to a different format.
Resolution
Perform the following local-change:
- Click the gear icon for the date property column in the report definition
- Set the column format to pxDateTime
- Open the format
- Set Type as Date
- Set Format as 01/01/2001
Published January 5, 2019 - 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.