How to correctly do time conversions

Options
abalo006
abalo006 Registered Posts: 29

TIME.PNG

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

step1.PNGstep2.PNG


Operating system used: windows

Answers

Setup Info
    Tags
      Help me…