How to correctly do time conversions

abalo006

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

Turribeach

EST is 5hs from UTC on autumn/winter:

https://en.wikipedia.org/wiki/Eastern_Time_Zone

Try with a summer date and you will see 4hs. START_TIME is not a proper parsed Date, it's a string.

abalo006

your right, thank you!