Support Article
Date time format not similar in report and in exported excel
SA-44199
Summary
Date time format is not similar in report and also in exported excel with Pega 7.2.
Error Messages
Not Applicable
Steps to Reproduce
Run "pyDailyProcessResolution" Out-of-the-box (OOTB) Report and export it to excel.
Root Cause
A defect in Pegasystems’ code or rules:
Export to Excel does not support the Custom date format option because it uses Excel to format dates, excel uses a different format syntax than Java's standard library.
Resolution
Perform the following local-change:
By changing the type of column format into DateTime instead of Date, this formats the date and outputs as text.
Published December 26, 2017 - 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.