Best answer

Sheets to Calendar Spanish Dates Issue


hello all!
here´s my issue, im using sheets to create events on calendar, when i add inputs from date 1 to 12 it reverses the dates to US format and adds those dates in the wrong months. Ive been looking for a workaround, but anything works… can u help me please? im testing the platform for a client and if we like it surely we will subscribe for pro!
The format we use us DD/MM/YYYY and between days 1 and 12 it formats MM/DD/YYYY

(just in case, i have all the timezones properly set up, in sheets, calendar and zapier.)

even using “plain text” or custom date on cell format, the issue persists….

icon

Best answer by Liz_Roberts 4 May 2020, 19:18

Hi @beto0m ,

Thanks for reaching out- happy to help!

The Google Cal API only accepts dates in the MM/DD/YYYY format (learn more here) so if your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.

Let us know if that does the trick- happy to answer any questions you may have!

View original

This topic has been closed for comments

2 replies

Userlevel 7
Badge +7

Hi @beto0m ,

Thanks for reaching out- happy to help!

The Google Cal API only accepts dates in the MM/DD/YYYY format (learn more here) so if your trigger is sending the data in DD/MM format, you can use a Formatter step to reformat the date.

Let us know if that does the trick- happy to answer any questions you may have!

hi thanks for the reply! i cant test if it works because it is a pro feautre… my client isnt sure about buying pro version yet… thanks anyways! ill figure out another way to do this automation!