Convert datetime to a given time zone
Hi,
I am creating a When Rule for comparing an "ActivationDate" datetime property with the current date.
Since PEGA is loading the "ActivationDate" value from data base converting it to GMT, it is substracting 2 hours (from CEST to GMT time zone).
To do properly the comparation and check if the "Activation" anniversary is today, I should transform the ActivationDate property to CEST time zone.
I am trying using the OOTB @DatetTime.toLOCAL function, but it seems not to work.
In the examples below:
- when using "CEST" is restarting 2 hours to the GMT time, and it should be 2 hours more.
- when using "Europe/Madrid" is returning the same hour that the GMT time, and if should be 2 hours more.
Any advice about how to use the toLOCAL function or how could the convertion be done?
Thank you
Miguel
***Edited by Moderator Marissa to update Platform Capability tags****
Morgan Stanley
IN
Hi Miguel,
You can give a try on the FormatDateTime function.
@FormatDateTime(@getCurrentTimeStamp(),"","Europe/Madrid","")
This will return the current time of CEST like 20200704T111559.696 GMT+02:00
To compare Dates, you can use the CompareDates function.
@CompareDates(@FormatDateTime(@getCurrentTimeStamp(),"","Europe/Madrid",""),@FormatDateTime(.ActivationDate,"","EST",""))
The above code might suit your scenario.
I hope it helps you!
Good Luck!
Pegasystems Inc.
ES
Hi Durai,
It seems being working fine.
Thank you!
Pegasystems Inc.
US
I assume this was to validate if an Action/Proposition is active or available to market to customers. If that is the case, is there a reason you are manually doing this validation and not using the pyIsActive in engagement policy condition, a filter shape on strategy or in a proposition filter? This check should already handle all locale issues for you and is the most performance efficient approach as a best practice.