Sep 23, 2022 07:54 AM
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.
Solved! Go to Solution.
Sep 26, 2022 09:20 AM
Sep 23, 2022 01:10 PM
I’ve created an instructional video for my time zone base. Link to the video in the description here:
Sep 23, 2022 01:28 PM
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.
Sep 23, 2022 01:48 PM
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
Sep 23, 2022 01:49 PM
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:
Sep 26, 2022 09:20 AM
Thank you so much! I appreciate your help. That worked great.
Aug 11, 2024 08:22 AM
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 ❤️