GMT to EST and EST to GMT

nimishan over 7 years ago

Hi,

I wanted to know the functions which helps me convert the datetime from GMT to EST and vice versa.

I need this logic to handle service Json response and request which deals with date in EST timezone.

Thanks in advance,
Nimisha.

Discussion posts and replies are publicly visible

0 ajinkyab277
Certified Lead Developer
over 7 years ago

you can use local and gmt function for date conversion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 shailendras593 over 7 years ago

Hi @nimishan having a look at functions like gmt() and local() might bring some help.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Krishna Chaitanya
A Score Level 1
over 7 years ago

Hi @ nimishan
use this code to convert time zone GMT to EST

append(
text(gmt(local(
now(),"EST")), "mm/dd/yyyy"), " EST")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Mike Schmitt
Certified Lead Developer
over 7 years ago

Also, I forget the specifics but in the past I've found it helps a lot to cast a date to string using tostring() when dealing with JSON conversion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel