Skip to main content
Best answer

Google Calendar - All day event 1 day earlier problem


Hi and apologies if this question has been answered somewhere else!

I want to create a calendar event after a trigger from Google Forms. All good until when creating the Calendar event and when toggling all day. When it is run, it creates a calendar event 1 day earlier then inputed.

Example: 
Input : 01/20/2025

Calendar Event Created on: 01/19/2025

I really don’t get what the problem is since it was working just fine a few weeks ago. 

Thanks for any help in this matter, very much appreciated!

Best answer by Troy Tessalone

Hi ​@noel167 

Help links for using GCal in Zaps: https://zapier.com/apps/google-calendar/integrations#help

My events are being created for the wrong date and/or time

There are a few reasons why events might be created for the wrong time or date by a Zap.

Are you creating an all-day event?

All-day events in Google Calendar end at midnight on the last day, so they're exclusive of the end date. For example, an event created via Zapier for August 10 - August 15 will appear to span August 10 - August 14 in Google Calendar, because the event will end at 12:00:00 on August 15.

To fix this:

  • Update your trigger data so that it lasts for an extra day.
  • Or, modify the end date in your Zap directly by adjusting the date/time to include +1d. This will cause the event to last for an extra day.

Are your timezone settings correct?

Check the timezone setting of both the trigger and action apps, and in Zapier. When the timezones don't match between apps, this can cause the event not to be created on the expected date and time. To fix this:

  • Change your timezone in your Zap settings
  • Check your Google Calendar timezone settings.
  • Refer to the help documentation of any other app in your Zap, to check the timezone on that app. You may also want to check that app's help pages on Zapier to see if there are any known limitations or restrictions for date/time fields.

Is the event created on the wrong date, specifically with the month and day switched?

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.

Are you using the "Quick Add Event" action?

If you're using the Quick Add Event action instead of the Create Detailed Event action, there are some specific guidelines that must be followed to make sure that Google Calendar can interpret the date and time correctly.

Is your detailed event appearing in the calendar for the same time the Zap ran?

This may happen if the start and end time/date are invalid. Events created with an invalid start or end date will be created for the time your Zap runs.

None of these describes my problem

If none of these steps addresses your problem, try to use Formatter by Zapier or date/time modifications to correct any date differences between apps.

View original
Did this topic help you find an answer to your question?

3 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 30739 replies
  • Answer
  • January 14, 2025

Hi ​@noel167 

Help links for using GCal in Zaps: https://zapier.com/apps/google-calendar/integrations#help

My events are being created for the wrong date and/or time

There are a few reasons why events might be created for the wrong time or date by a Zap.

Are you creating an all-day event?

All-day events in Google Calendar end at midnight on the last day, so they're exclusive of the end date. For example, an event created via Zapier for August 10 - August 15 will appear to span August 10 - August 14 in Google Calendar, because the event will end at 12:00:00 on August 15.

To fix this:

  • Update your trigger data so that it lasts for an extra day.
  • Or, modify the end date in your Zap directly by adjusting the date/time to include +1d. This will cause the event to last for an extra day.

Are your timezone settings correct?

Check the timezone setting of both the trigger and action apps, and in Zapier. When the timezones don't match between apps, this can cause the event not to be created on the expected date and time. To fix this:

  • Change your timezone in your Zap settings
  • Check your Google Calendar timezone settings.
  • Refer to the help documentation of any other app in your Zap, to check the timezone on that app. You may also want to check that app's help pages on Zapier to see if there are any known limitations or restrictions for date/time fields.

Is the event created on the wrong date, specifically with the month and day switched?

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.

Are you using the "Quick Add Event" action?

If you're using the Quick Add Event action instead of the Create Detailed Event action, there are some specific guidelines that must be followed to make sure that Google Calendar can interpret the date and time correctly.

Is your detailed event appearing in the calendar for the same time the Zap ran?

This may happen if the start and end time/date are invalid. Events created with an invalid start or end date will be created for the time your Zap runs.

None of these describes my problem

If none of these steps addresses your problem, try to use Formatter by Zapier or date/time modifications to correct any date differences between apps.


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2203 replies
  • January 21, 2025

Hi ​@noel167,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


  • New
  • 1 reply
  • February 3, 2025

I recently started having the same problem with a Zap that worked fine previously.

It isn’t the date inclusive issue with all day events, where the last day isn’t included.
Like Noel described, it is the complete opposite. Zapier randomly changes the date inputs to be 1 day earlier when creating the event.
I’ll attach images to make this as clear as I can.

Here are screenshots from the most recent Zap run.
It is intended to create a 2 day all-day event from May 1st to May 2nd. See that the inputs are correctly set to book from midnight of the first day, to midnight of the day after the last day.


However here are the outputs of the Zap run.
 


Exactly as described by Noel, the start and end of the resulting event are exactly 24 hours earlier than the inputs.
​​​​​​​
Before you ask, I have already checked the following:
・The step is “create detailed event”
・My timezone is set correctly
・I used a formatting step to try different date formats, but the same problem persists.

Can you please look into this and see if the problem is originating on your end?