Pega Default Date Value is stored as 01011970 in database
When setting the Date property as blank, the Date value is stored as '01011970' in the database.
Steps to Reproduce
- Add a repeat grid sourced with an editable datapage containing a Date property as a column whose value changes dynamically using a declare expression depending on a boolean property.
- Perform a filter on the date property.
An issue in the custom application code or rules.
Perform the following local-change:
Alter the declare expression to set the Date to avoid the below condition in a single statement as displayed in the below image.
For example, condition: .NRFI = true ? @getCurrentDateStamp(): ""
Instead, use the 'Whenever used (if - otherwise)' step in the declare expression and set the value as blank as displayed below to avoid '01011970' in the database.
Additionally, create and use the following Dynamic System Setting (DSS) related to the default date.
|Pega-IntegrationEngine. disableEpochDateTime||When a DateTime property is set to an empty value, it returns the epoch DateTime (01-jan-1970) by default. Set this value to "true" to have the property return no value.|