Question
BNY Mellon
BNY Mellon
IN
BNY Mellon
Posted: Oct 30, 2019
Last activity: Nov 3, 2019
Last activity: 3 Nov 2019 0:10 EDT
Closed
CurrentDateTime function returns a different time zone value
We want to the system to return date time stamp of US (EST) time zone. But the system is returning the date time stamp from UK time zone. Where can we control the system time zone?
***Edited by Moderator Marissa to update platform capability tags****
Posted: 6 years ago
PEGA
Pegasystems Inc.
CA
Posted: 6 years ago
Pegasystems Inc.
Pegasystems Inc.
IN
Hi Venkatesh,
Thanks for posting the query.
Get the Time in GMT with the function @CurrentDateTime().
Then use function @FormatDateTime(@CurrentDateTime(), "yyyy-MM-dd","America/New_York","en_US") to get the DateTime in US Timezone.
As the description on the history tab of CurrentDateTime function states, it always returns the time in GMT (UTC). If you need the time in any other time zone, you will have to pass the output of CurrentDateTime as strDateTime and America/New_York as strTimeZone to FormatDateTime function. It is critical to use America/New_York and not EST to ensure you get correct results regardless of whether daylight savings is on or not.