Using Lookup on a date field without time returns the date adjusted

Topic Labels: Dates & Timezones
728 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I am trying to understand the logic behind date and time fields. When I have a field in one table that is just set as a DATE (no time), and I do a lookup of that date in another table with just DATE (no time), it adjusts the date to be one day before what I have set in the originating table. When I add the time I can see it is adjusting for timezone, but the date I have set it with my timezone in mind already?

1 Reply 1

Hi @Faculty_Scheduling

Airtable stores all dates and times in the GMT timezone. If you check off “Use the same time zone (GMT) for all collaborators”, it does adjust the date and time. See this topic for more info.