This Zap that I’ve been using for years now started showing an issue today that I’ve never experienced before. No matter what date I put in the sheet (which is automatically populated from a Google Form), the resulting Calendar item shows an end date in 2024. Any ideas on what might be causing this and what I can do to fix this?
Thanks.
Best answer by Troy Tessalone
Hi
Good question.
There is a space missing between the 2 mapped variables in the End Date & Time.
Regardless of the settings in your Google Calendar, data sent through their API (as Zapier does) must be in MM/DD/YYYY format. So, if you try to send an event for April 7, 2021 as 07/04/2021, Google Calendar will interpret that as July 4, 2021. The dates need to be in MM/DD/YYYY format to ensure Google Calendar adds the event to the correct date(s). If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.
+14Hi
Good question.
There is a space missing between the 2 mapped variables in the End Date & Time.
Regardless of the settings in your Google Calendar, data sent through their API (as Zapier does) must be in MM/DD/YYYY format. So, if you try to send an event for April 7, 2021 as 07/04/2021, Google Calendar will interpret that as July 4, 2021. The dates need to be in MM/DD/YYYY format to ensure Google Calendar adds the event to the correct date(s). If your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.
Thanks a ton! That worked like a charm.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
