​@Fede_ 

Use a Formatter by Zapier step to convert to a date/time format you require.
 

Hope that helps

Hi ​@Fede_ 

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

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.

​@Troy Tessalone ​@Fede_ 

That’s interesting as all the dates that come from my Google Calendar have been in the ISO format YYYY-MM-DD. Creating events using the ISO format with time has also always worked for me. But I have never had to used just a date without time.
 

I wonder if that’s the difference the time part?

​@Fede_ 

Help links for using the Formatter Zap app: https://zapier.com/apps/formatter/help

​@Fede_ 

Use a Formatter by Zapier step to convert to a date/time format you require.
 

 

 

 

Hope that helps

im using the free trial, and i can only use 3 steps, but thank you

i only have 2 steps*
for doing for the following steps:
1)Take the email from gmail and send it in automatic to the mailbox zapier, that take the data from the email and send it to the zap

2)Than create a event in google calendar
 

but it creates with a different format date,
format europe: dd/mm/yyyy
format america: mm/dd/yyyy
Example
date input in europe: 05/12/2024 so i expect an event in the 5 december 2024
event creates in the date america:  12 may 2024

Hi ​@Fede_,

Currently, the only way to change the time format is to utilize a Formatter step. You could upgrade your free trial so that your Zap is configured correctly with the time using Google Calendar.

​@Fede_ 

Here is a workaround to avoid having to upgrade your free account. 

1. Create a Google Worksheet
   Column A Call Date US
   Column B Call Date EU
   Column C Time
   Column D ISO
   In column B add the formula   =TEXT(A2, "DD/MM/YYYY")
   In column D add the code 
   =TEXT(DATE(RIGHT(B2,4),MID(B2,4,2),LEFT(B2,2)),"YYYY-MM-DD") & "T" & TEXT(C2,"HH:MM:SS") & "Z"
    
2. Use a Google Sheets Zap Step Update Spreadsheet Row
   Send your US Date to Row 2 Col A “Date US”
   Your Time in a HH:MM:SS format
   Once the row is update the Col B “Date EU” will be in the correct format.
   Col D will be in the ISO Format with start time
   (You should be able to work out how to add an end time by yourself.)
   
   This can now be selected for use in steps below. 
   
   I used a Google Calendar Create Detailed Event 
   
   I would recommend using the ISO format as you can attach time to it very easily and prevent calendar events all starting at midnight. 
    

   

   

   

   
   I hope that’s useful.

Hi there, ​@Fede_ 

How did you get on with this—did the workaround Badger suggested do the trick?

Looking forward to hearing from you!

​@SamB 

i just take the data from the mail like:
Europe format: 19/12/2024

Take data: p0/p1/p2

use it in the start date-time in zap calendar like: p1/p0/p2 and it worked

Wow! Thank you for confirming that Badger’s suggestion got the Zap running. This will significantly help our Community members to have as a reference for the same issue.