Skip to main content

Is there a way to set the time zone for all tables in a base? I just noticed that my “where Ordered is today” filtered out all orders and it’s only 6:31pm – the day is not over yet. :neutral_face:

Time Zones need to be set on a field-by-field basis.

Time zones can be tricky to work with, so I’ve created a training video & a sample base on the topic here: Time Zones: Working with multiple different time zones in Airtable

Hope this helps!

- ScottWorld, Expert Airtable Consultant


@ScottWorld This video is very helpful for understanding how Airtable handles dates, so thank you for that! 

I would say, however, that the original poster's question still remains, and I share it: how do you get a view filter to honor your local time zone, if all dates are actually stored in GMT? 

Airtable only seems to give you the option of manually setting the date field's time zone if you also enable the time option. But let's say I only want a date in format MM/DD/YYYY. Airtable does not give me the option to designate which time zone this field should be tracking, and since there's also no global time zone setting, it appears that everyone is forced to operate as though they work in Europe. 

Maybe this isn't an issue with a single date field, but particularly when you try to roll up or look up a date from a linked record in another table, it gets complicated very quickly, and again you seem forced to operate as though you work in GMT. This isn't helpful when trying to construct view filters, and I can't seem to figure out a way around it. Same as the OP, every day at 6 p.m., "today" views break because AT insists that it's tomorrow.


@ScottWorld This video is very helpful for understanding how Airtable handles dates, so thank you for that! 

I would say, however, that the original poster's question still remains, and I share it: how do you get a view filter to honor your local time zone, if all dates are actually stored in GMT? 

Airtable only seems to give you the option of manually setting the date field's time zone if you also enable the time option. But let's say I only want a date in format MM/DD/YYYY. Airtable does not give me the option to designate which time zone this field should be tracking, and since there's also no global time zone setting, it appears that everyone is forced to operate as though they work in Europe. 

Maybe this isn't an issue with a single date field, but particularly when you try to roll up or look up a date from a linked record in another table, it gets complicated very quickly, and again you seem forced to operate as though you work in GMT. This isn't helpful when trying to construct view filters, and I can't seem to figure out a way around it. Same as the OP, every day at 6 p.m., "today" views break because AT insists that it's tomorrow.


Actually, correction. It's even more mysterious than what I described above. 

I have some filters set up, and they're all defaulting to PDT, my time zone, as pictured below.

That first filter is for the field **ALL PRODUCTION DATES**. If we look at that field's configuration, however, we'll see that I have the formatting set to GMT/UTC.

If I don't use GMT/UTC on my **ALL PRODUCTION DATES** lookup field, then they get displayed in the wrong time zone. If I change it to America/Los_Angeles (PDT), then they're *also* displayed in the wrong time zone. It's a head scratcher, and I'd love if someone could help me figure out how to get view filters to work together with dates in lookups and rollups.


I remember dealing with this issue years ago, which I have just rediscovered as a problem, albeit in a new computer.  When I dealt with this previously, I was advised by Airtable that it was tied to either my browser language or Windows language and timezone settings. I cant quite recall right now. Our IT people had a hard time with it because we had to change those settings on our machines, when no one else was using Airtable in the organisation.  Im now using Vivaldi instead of Chrome, and I have a new PC and I have just noticed this problem.. .I guess I will have to go hunting again.  But those are the two places I have been told were relevant in the past…   I trust that might help, even though this thread is now aged somewhat.