Select timezone for each record

Topic Labels: Dates & Timezones
603 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’ve got a table set up which is to hold flight data. So I have airport from, to and date/time fields. I would like to have the timezone listed in the time field as it is always local to the origin or destination. Is this possible? When I select show timezone it appears at GMT automatcially but I can’t then change it.


2 Replies 2

Welcome to the community, @Nat8100!

This is very tricky in Airtable because the timezone would need to be in another field, but you can get the results you’re looking for.

Check out my sample time zone base & its accompanying training video. It’s pretty complex, so take some time to digest it all:

Thanks for your reply. I’ve downloaded your table so will see if I can make something work with that.