Skip to main content

Airtable automation to add event in Google Calender parsing date and time incorrectly

  • March 18, 2022
  • 1 reply
  • 18 views

I have a form set up for Realtors wanting to schedule a showing for a property. I am using the Date field (with time enabled) as the “Start Date and Time” and a DATEADD field that calculates a new Date and Time based on a Duration field. Everything is working correctly in the Airtable spreadsheet. However, if I attempt to automate a trigger to set up the event in Google Calendar, the Date and Time are not correct. It seems that the data is being parsed incorrectly.

This topic has been closed for replies.

1 reply

  • Author
  • New Participant
  • March 18, 2022

**This is the Data being returned from the Airtable Fields

This is what is being pushed to Google Calendar

I have tried setting the Date Format switch
“Use the same time zone (GMT) for all collaborators” off and on and get the same result