convert from GMT Time to Eastern Standard Time(EST)

[evinothk]

21-Jul-2023 08:15:35 AM- This is a date with GMT time. How to convert to EST including date

[cjaneczko · Accepted solution]

Add a formula and adjust the time in hours accordingly. I believe its 5 hours. DateTime_Out would be updated to the date field.

DateTimeAdd([DateTime_Out], -5, "hours")

[alexnajm]

First it needs to be converted to a date time value, then DateTimeAdd will do the trick!