How to correctly do time conversions

abalo006 Registered Posts: 29


I have a column that has been parsed and is in UTC, when I try to format the date to be in eastern / New York time I get a new column that is -5 hours, but isn't the current the current difference -4 hours? I'm sure this has something to do with daylight savings time vs normal time, but I just want to ensure that my formula remains working even when times are changed by an hour due to daylight savings.

does anybody know how I can get the correct time difference from UTC to ET?

I've attached the steps I'm currently using below


Operating system used: windows


Setup Info
      Help me…