Skip to main content

We recently updated our AirTable interface to sync directly with our google calendar. We deal with scheduling out many projects across multiple calendars with subcontractors and we use all day events to do so. When I tried to sync our calendars without incorporating times, all of our all-day events were extended out by one day (ex: All Day Event on 7/8/25 in Google Calendar would translate to Start/End: 7/8/25 → 7/9/25 in AirTable when times are excluded). I’m assuming that this stems from Google Calendar and AirTable having different “all day” time functionality. Is there a way to fix this? Here is the result I’m looking for:

  1. All Day events syncing from Google Calendar to AirTable exactly as shown on Google Calendar (ex. All Day Event on 7/8/25 in Google Calendar has a Start/End Date of 7/8/25 → 7/8/25 on AirTable)
  2. No times in the date field

Please keep in mind:

  • We are currently on the Teams plan for our level of permissions.
  • We are not using automations for any of our date creation.
  • We are using a one way sync from Google Calendar to AirTable. All calendar events are created and edited via Google Calendar alone.
  • We do not want to change the way we input dates into Google Calendar (ie. we don’t want to start inputting all-day events to end at 11:59pm in order to translate correctly to AirTable)

Thank you to anyone who can help me troubleshoot this problem!

Hmm… that’s strange… I’m not seeing this on my end.

I wonder if your time zone settings are different between Google Calendar and Airtable?

Airtable sets the time zone on a field-by-field basis, so you would need to go into your Start Date field and your End Date field to check the time zones there.

Then, check to see if that matches your time zone in Google Calendar?

- ScottWorld, Expert Airtable Consultant

Hi Scott!

Thank you so much for taking the time to look into this for me!

I just checked out your recommendation. It looks like I’m only able to change time zone settings if I have Times enabled on my date fields. I looked to adjust them once Times were disabled and didn’t see the option to.

I’ve attached a few sample screenshots of what I’m getting…

Before I disable Times...

After I disable Times…

Is this the result you’re getting?

Ah, very interesting… I’m getting the same exact results when I turn off the time!

As far as I’m concerned, this is a bug because an all-day event does NOT end on the NEXT DAY. It ends on the CURRENT DAY.

If I were you, I would definitely open up a support ticket with support@airtable.com about this. But be forewarned that even if they’re interested in solving this issue, it could be months (or years) before they feel like it is a high-enough priority to fix.

In the meantime, you could do 2 things to workaround this issue:

  1. Leave times turned on, although that would get very annoying on the calendar view.
     
  2. Your best long-term solution would be to create a formula field that figures out what the REAL END DATE is supposed to be, and then use that field on your calendar as the end date. (And you will also want to turn OFF the time in this formula field, too.)

    Your formula for your new “REAL END DATE” formula field would look like this:  
    IF(
    {All Day},
    DATEADD(End,-1,'day'),
    End
    )

 

 

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Thank you so much, Scott! I’ll work on implementing this first thing in the morning as well as open up a support ticket. I appreciate you putting the time into this to help me! I’ll keep you updated if I have trouble with the formula, and we will keep you in mind if we need a consultant in the future.

You’re welcome! Glad I could help! :)

Terms & Conditions