Skip to main content

Not understanding how SET_TIMEZONE and DATETIME_PARSE work together

  • October 13, 2024
  • 1 reply
  • 10 views
R
Forum|alt.badge.img+3

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. 

(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!

 

This topic has been closed for replies.

1 reply

R
Forum|alt.badge.img+3
  • Rose_Wilson
  • Author
  • New Participant
  • October 13, 2024

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. 

Terms & ConditionsAccessibility statement