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

Topic Labels: Automations
636 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1
4 - Data Explorer
4 - Data Explorer

**This is the Data being returned from the Airtable Fields
Screen Shot 2022-03-18 at 1.10.13 PM

This is what is being pushed to Google Calendar
Screen Shot 2022-03-18 at 1.08.42 PM

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