Help

Re: Timezone Formula for US States

1457 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Adam_Kramer
6 - Interface Innovator
6 - Interface Innovator

I thought this might be useful for others, as I had to figure out how to do it for myself to automate sending emails during the right timezone for the recipient; here’s a list of all the timezones for US states:

IF(OR({State}="CA", {State}="WA", {State}="OR", {State}="NV"), "PST", IF(OR({State}="MT", {State}="ID", {State}="WY", {State}="SD", {State}="UT", {State}="CO", {State}="AZ", {State}="NM"), "MST", IF(OR({State}="ND", {State}="MN", {State}="WI", {State}="IA", {State}="NE", {State}="IL", {State}="KS", {State}="MO", {State}="OK", {State}="AR", {State}="TN", {State}="TX", {State}="LA", {State}="MS", {State}="AL"), "CST", IF(OR({State}="MI", {State}="IN", {State}="OH", {State}="ME", {State}="VT", {State}="NY", {State}="NH", {State}="MA", {State}="CT", {State}="RI", {State}="PA", {State}="NJ", {State}="MD", {State}="DE", {State}="WV", {State}="KY", {State}="VA", {State}="NC", {State}="SC", {State}="GA", {State}="FL", {State}="DC"), "EST", IF({State}="AK", "AST", IF({State}="HI", "HST"))))))

There are some rare exceptions of states in two timezones and some states that don’t observe Daylight Savings Time that I definitely didn’t account for, but hey – you get what you pay for guys :slightly_smiling_face:

3 Replies 3
Macon
4 - Data Explorer
4 - Data Explorer

This just saved me so much time. Hope to pay it forward one day. 🙏

nil
4 - Data Explorer
4 - Data Explorer

 download.jpg

black-wallpaper-15.jpg