Help

Not understanding how SET_TIMEZONE and DATETIME_PARSE work together

Topic Labels: Formulas
279 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Rose_Wilson
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, I'm trying to extract the first set of data in this single select field using LEFT() and then converting that into a date field. 

The data extracted will be in Chicago time. When I run this formula, it assumed that the date is in GMT,  and doesn't respect the SET_TIMEZONE. 

Rose_Wilson_0-1728850566451.png

(note last entry where the time should be 3pm but the formula returns 10 pm central)

Any ideas what I'm doing wrong here?

Thanks!

 

1 Reply 1
Rose_Wilson
5 - Automation Enthusiast
5 - Automation Enthusiast

Nevermind, I got around this with DATEADD instead. Still confused about SET_TIMEZONE, but since this is for a single weekend event, I shouldn't have to worry about DST and a static DATEADD should work fine.