Formula to change timezone based on single-select column

[KP217]

Hello,
I am trying to take one column with a day/hour field (Start Date) and use a Single-Select (Time zone) to create an updated day/hour column.
Currently, I use New York time on all the other dates but I need to be able to see a different version of the time in cases when I am collaborating with people internationally.
Time zones would be ‘Africa/Laos’,‘Africa/Maputo’,‘Africa/Nairobi’ etc.
Any help would be much appreciated!

Edit: I have looked at this sample base and get what it’s trying to do, but I don’t know how to alter it for my purpose.

[ScottWorld]

I’ve created an instructional video for my time zone base. Link to the video in the description here:

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...

[KP217]

Hi Scott. Thanks! I did view it when I copied the base. Ordinarily if I’m given the base to work with, I can update it. However, these date/time formulas are more difficult and I can’t figure out how to update it for my purpose. Any advice on helping me move from the example to my needs would be much appreciated.

[Vivid-Squid]

You can convert the time zone with this formula. Assuming two existing fields, Start Date (Date) and Time Zone (Single Select)

DATETIME_FORMAT(SET_TIMEZONE({Start Date}, {Time Zone}),'LLLL')

You can populate your Single Select with timezones from this list: SET_TIMEZONE - Supported Timezones | Airtable Support

[ScottWorld]

All the formulas are already set for you. If you need to add additional time zones, then be sure to pull from the list of time zones on this page:

support.airtable.com

SET_TIMEZONE - Supported Timezones | Airtable Support

The SET_TIMEZONE function will allow you to set the timezone for the data from a date type field. This is written in the form...

[KP217 · Accepted solution]

Thank you so much! I appreciate your help. That worked great.

[Andrewp]

you must use America/New_York or America/Chicago etc. as your single select format and NOT 'America/New_York' or 'America/Chicago' btw .. the apostrophes will throw it off.

+ thank you all above ❤️