Question
TCS
IN
Last activity: 21 Nov 2017 4:35 EST
Converting UTC to GMT timing
I'm looking for a function which can convert UTC time to GMT.
Tried using @DateTime.FormatDateTime function, but it results null value when DateTime string is my input value in UTC. Strangely it works for @CurrentDatetime()
More details here
*Updated to add more info*
I'm using Version 7.2.
And am trying to convert a parameter with value 2017-04-07T05:00:00.000Z to the format 20170407T050000.000 GMT
The main purpose of this conversion is to make use of @DateTime.CompareDates() functions which right now is resulting in Invalid date format error with UTC format. ( it works correctly with GMT format)
Thanks
***Updated by moderator: Lochan to add Categories***
Pegasystems Inc.
IN
Hi,
Can you check below discussion should be helpful
https://collaborate.pega.com/question/converting-date-time-utc
Thank You
Pegasystems Inc.
IN
Hi Aparna,
I looked into your reply on the referenced post - Could this shed some light? Coordinated Universal Time (UTC)
Just to cover all bases - what is your Pega version?
Regards,
TCS
IN
Hi Lochana,
I'm using Version 7.2.
And am trying to convert a parameter with value 2017-04-07T05:00:00.000Z to the format 20170407T050000.000 GMT
The main purpose of this conversion is to make use of @DateTime.CompareDates() functions which right now is resulting in Invalid date format error with UTC format. ( it works correctly with GMT format)
Thanks,
Aparna
Pegasystems Inc.
IN
Hi Aparna,
I have not tried this but if you are sure of the extra character(-,/) etc in the input then just assign those values to string.
Then use replace function to get rid of character, assign it back to required date property and the use format functions as per your requirements.
Thanks,
Ujjwal