Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi!

I created a zap that takes birtday dates from a google spreadsheet and put them as an event in a calendar. The problem is that some dates a put correctly, and others date and month is mixed (ex. if the birthday is 1st of September, but in calendar is shown as 9th of January).

This happens only to some of the entries even if the entire column has the same format, the calendar is formated as well.

I created a helping column that formats the birtday as mm/dd/yyyy (required by Calendar API) it didn’t work. I know there is a Formater tool, but I’m on free tier. Is there a solution to fix it without formatter? And is the problem in the format or it can be other thing?

Looks like the issue is that Google Calendar isn’t reading the date format from your Google Sheet correctly.

Google Calendar only accepts dates in these formats:

- For just a date: YYYY-MM-DD (example: 2025-09-01)

- For date + time: YYYY-MM-DDTHH:MM:SSZ (example: 2025-09-01T14:00:00Z)

The problem is that Google Sheets sometimes stores dates differently depending on your regional settings (like DD/MM vs MM/DD), which is why the day and month get flipped.

 Since you’re on the free plan and can’t use the Formatter, a quick fix is to add a helper column in your Sheet with this formula:

 =TEXT(A2,"yyyy-mm-dd")

(assuming A2 is the date cell).

Then, in your Zap, map this helper column instead of the original date column. That way Google Calendar will always get the date in the correct format.

Give that a try, and if it still doesn’t work, share a screenshot of your Google Sheet and the field mapping in Zapier so we can take a closer look.

Hi ​@DanaG 

Try this Zap action: Formatter > Dates / Times > Format

Format into ISO: YYYY-MM-DD

You can leave the From Format field blank.

NOTE: Only the required fields need values.

 

Hey there ​@DanaG 👋 How did you get on with the potential fixes Ashar Malik Easyaiz and Troy suggested? Did either of those do the trick?

Want to make sure this got sorted 🙂

Terms & ConditionsAccessibility statement