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!