Best answer

Why did the date change when update to google calendar from google sheet?

  • 21 March 2020
  • 1 reply
  • 56 views

I set the Zap which is create the event to google calendar from google sheet.

It change the date data as below.

 

 

What is the problem and how can I resolve this issue?

icon

Best answer by AndrewJDavison_Luhhu 21 March 2020, 12:38

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +10

Hi @Allen Kim 

Basically, Zapier/Google Sheets doesn’t understand that input date format, so it just defaults to using today's date.

You should be able to use a “Formatter->Date/Time->Format” step to correct the format before you send it:

https://zapier.com/help/create/format/modify-date-formats-in-zaps