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?
Best answer
Why did the date change when update to google calendar from google sheet?
Best answer by AndrewJDavison_LuhhuBest answer by AndrewJDavison_Luhhu
Hi
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
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
+10- Zapier Expert
- 2437 replies
- Answer
Hi
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.