Support Article

Export to Excel displays wrong date time format

SA-32387

Summary



The DateTime property in a report definition is designed to display in Date format. This property appears in DateTime format instead of the designed format when the report is exported to Excel, but it appears fine when it is exported to PDF.

Error Messages

Not Applicable

Steps to Reproduce
  1. Configure a report definition with DateTime property.
  2. Set the format for the column as Date.

Root Cause



A defect in Pegasystems' code or rules:
RULE-OBJ-HTML RULE-OBJ-REPORT-DEFINITION PZLISTVIEWEXCELDATA #20140722T202716.887 GMT


Resolution



Apply HFix-31398.

Published January 12, 2017 - Updated January 30, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.