- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 13, 2024 01:13 PM - edited ‎Oct 13, 2024 01:16 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Oct 13, 2024 02:02 PM
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.