Hi, I just realized that the system stores the date and time in UTC. I need to display the Created Time in GMT.
What formula can I use in a Generic Inquiry (GI) to convert the UTC time to GMT?
Thanks!
Solved
Converting time from UTC to time zone time
Best answer by MWijesuriya43
I have done a little change to ur formula and it worked.
= DateAdd([SOOrder.CreatedDateTime],'H', 11 )
Thank you for the help.
Hi
UTC and GMT are the same (UTC+0), No conversion is needed in the GI.
Just use:
= [CreatedDateTime]
Only use DateAdd if you need to shift to a different time zone.
Hi
yes
You can use the following formulas accordingly.
= DateAdd(hour, 10, [CreatedDateTime])
converts UTC → AEST
= DateAdd(hour, 11, [CreatedDateTime])
converts UTC → AEDT
It works correctly as long as the stored value is UTC.
Hope this help you.
Unable to cast object of type 'System.Int32' to type 'System.String'. Do u have any idea?
I have done a little change to ur formula and it worked.
= DateAdd([SOOrder.CreatedDateTime],'H', 11 )
Thank you for the help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.