How to read High End Date values in PEGA DSM 7.3
Currently we are running data flows to retrieve customer information within PEGA DSM 7.3. But for date columns with high end date values ( 31-12-9999) it is reading as 31-12-1999. The property mapped in the class mapping to these high end date columns is of "DateTime" type. Can you let me know, what should be done to retrieve the values correctly? Have verified in the database the value is ( 31-12-9999)
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
Hello Ipsita,
I have tested the mentioned date time value in my local Pega 7.2.2 and able to retrieve the same value .
Create a SR with GCS to see if there are any issues dataflow execution .
Thanks,
Hello Ipsita,
I have tested the mentioned date time value in my local Pega 7.2.2 and able to retrieve the same value .
Create a SR with GCS to see if there are any issues dataflow execution .
Thanks,
Arun
Pegasystems Inc.
US
This comes down to understanding how dates are stored internally. Standard dates only go up until the year 2820 or something like that. If you want a maximum "high end" date to compare others against, create something with "new Date (Long.MAX_VALUE)".
If you absolutely have to have something beyond the highest date used by Java - you'll need to use something else.
EPAM Systems, Inc.
ES
I would second my colleague @PaulGentile_GCS explanation. You need to create your own custom Date with desired MAX_VALUE.
Though, could you explain any specific business requirement why you need such a high-end date.