Time Zone not updating correctly

[Charlotte_Ossom]

Hi all,

I’ve been struggling with the SET_TIMEZONE feature for about 20 minutes now and frankly I’m over it, so I’m coming to you all.

I’m trying to display the times that some orders were made in the local time zone of the person that made the order. I have three columns: Time Zone (which is the local time zone of the buyer), Order Time & Date (CET) (which is my time zone. all time stamps arrive in CET), and Order Date & Time (Local) (which is the field I am trying to calculate).

I have set the following formula in the last column:

IF({Time Zone}="Alaska",SET_TIMEZONE({Order Date & Time},'America/Juneau'),IF({Time Zone}="Hawaii",SET_TIMEZONE({Order Date & Time},'Pacific/Honolulu'),IF({Time Zone}="Eastern",SET_TIMEZONE({Order Date & Time},'America/Kentucky/Louisville'),IF({Time Zone}="Pacific",SET_TIMEZONE({Order Date & Time},'America/Los_Angeles'),IF({Time Zone}="Central",SET_TIMEZONE({Order Date & Time},'America/Mexico_City'),IF({Time Zone}="Mountain",SET_TIMEZONE({Order Date & Time},'America/Boise'),{Order Date & Time}))))))

This formula is intended to display the time the order was made in the local timezone of the buyer based on the option selected in the Time Zone column.

However this does not work. I even tried removing the whole formula and just using a simple SET_TIMEZONE({Order Date & Time},‘America/Boise’) to test, and it still doesn’t work.

What happens is, no matter what time zone I set the resulting formula is always 2 hours ahead.. I’ve included a screenshot of this as well

I would greatly appreciate any help you can give me on this issue!

[ScottWorld · Accepted solution]

My sample base and accompanying training video will help you solve this problem:

Airtable

Time Zones: Working with multiple different time zones in Airtable - Airtable...

This Airtable base solves the problem of events taking place in different time zones, and users wanting to know what time those events are taking place in...

[Charlotte_Ossom]

Thanks a lot fot this! it worked great !

[ScottWorld]

Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face: