Skip to main content

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!

 

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. 

Reply


Terms & Conditions