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

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?

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.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.