addDays(String, int, boolean, String) is inconsistent. When 1 business day is added to the date I am getting the result as the same day as input
We have a requirement where we need to add(1 or 2 or 5) days to the case creation date. I am using the addDays() functon where I pass a dateTime and add number of days accoriding to the requirement. We are using our own calendar which is set in CST time zone and have our set of holidays defined. We are storing the result in DateTime property. We are facing inconsistency where when we add one day to the dateTime passed we are getting the same date. Like, if I pass "20161228T150000.532 GMT" and add one day using addDays(DateTime, 1, true, CalendarName) I am getting the result as "20161228T183000.000 GMT". We are facing the issue only in UAT testing environment. We are not facing the issue in lower environments. The only differene I could find between the two environments is that lower environment server is located in CST time zone and UAT environment server is located in EST time zone.
One important thing to note is that we are facing the issue only when we are running the function before 3PM IST(Indian Standard Time). We are not facing the issue after 3 PM IST on the same day even though we pass the same "20161228T150000.532 GMT" value.
***Updated by moderator: Lochan to add Categories***
Accepted Solution
Pegasystems Inc.
IN
Hi Aravinth,
If the property pyDisableTimezoneConversion is set to true disable time zone conversion for date/datetime fields globally. Time zone will default to constant "GMT".
This property is set in OOTB ApplicationProfileSetup or similar activity.
Could you please check if the extension activity is overridden?
Best Regards,
Mounika
Pegasystems Inc.
IN
Also, the Days RUF with 4 parameters ADDDAYS--(STRING,INT,BOOLEAN,STRING) has been set to use the GMT timezone in cases where the use business calendar parameter is sent as false.
Tata Consultancy Services
US
Hi Mounika,
I checked the property and it is set as false. I also was able to track down some more things in the problem. The issue happens only if the operator ID is set to IST timeZone. Is there a way to solve this problem so as to get the date regardless of the timezone of the operator
Tata Consultancy Services
US
Update: Seems like the issue is because pyDisableTimezoneConversion is set to false. So created a new java function to add Days which won't convert the date automatically.
Pegasystems Inc.
GB
Typically you can always expect problems when using "Date" functions with a DateTime Property; especially if your timezone is ahead of GMT. In this instance it would be better to have a new "Date" Property, eg. CreateDate and then use this for your "calculations". You can probably set the value using a Declarative Expression based upon pxCreateDateTime.