In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

convert from GMT Time to Eastern Standard Time(EST)

evinothk
7 - Meteor

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

2 REPLIES 2
cjaneczko
13 - Pulsar

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
18 - Pollux
18 - Pollux

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

Labels
Top Solution Authors