Last activity: 11 Dec 2019 4:16 EST
Excel sets default value 1/1/70 in empty cells for date property
I have used pxGenerateExcelFile to generate excel sheet. In empty cells excel sets default value.For Date 1/1/70
***Edited by Moderator Marissa to update platform capability tags****
What version of Pega are you on?
pega 8.2 version
I am using pega 8.2 version
Do you have dynamic system setting (DSS) "disableEpochDateTime" set to true?
What is the version of Pega you are using?
Please check below two pdn links. This is an expected behavior. The suggested local change is to set the following Dynamic system setting's value to "true".
1. for Date property : use dynamic system setting "disableEpochDate".
2. for DateTime property : use dynamic system setting "disableEpochDateTime".
both of these DSS's owning ruleset is "Pega-IntegrationEngine".
I am using pega 8.2 version there is no DSS. I have created new DSS it is not working.
It is expected behavior that the clipboard layer will not return an empty value.
The disableEpochDateTime DSS is applicable only for the integration layer which relies on following API internally - com.pega.pegarules.pub.util.PRDateFormat.formatXSDDateTime(Date). As far as the SET action/property-set methods in the clipboard layer return the default value for properties of type DateTime and the default value is 01-jan-1970.
Check this link for additional info: https://community.pega.com/support/support-articles/blank-dates-displaying-1970
From what I know, this may be addressed in future release. When the support article is published, I will try to share it.
Thanks for the information.
This was fixed in all 8.x versions