Skip to main content

Not understanding how SET_TIMEZONE and DATETIME_PARSE work together

  • October 13, 2024
  • 1 reply
  • 8 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!

 

1 Attachments

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