About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Sync from Google Calendar to Zoho Calendar - Time Format is Incorrect

  • 9 February 2024
  • 15 replies
  • 57 views
J

I have a Zap setup to create a Zoho Calendar event anytime a new Google Calendar event is made. The time in Zoho is incorrect. Zoho is dropping the 1 in front of 18:00 and 19:00 and making it 8:00 and 9:00 see below:

Both Calendars are on 12 hour time

Here are the run details:

Google Calendar: start: dateTime: 2024-02-09T18:00:00-05:00

Google Calendar end: dateTime: 2024-02-09T19:00:00-05:00

Zoho Calendar: start: 20240209T080000-0500

Zoho Calendar end: 20240209T090000-0500

icon

Best answer by SamB 15 May 2024, 13:35

View original

15 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @JamesLMartin 

For us to have full context, please post screenshots with how your Zap steps are outlined and configured, thanks.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

 

J

 

J

 

J

 

Troy Tessalone
Userlevel 7
Badge +14

@JamesLMartin 

Try adding a Formatter > Date & Time > Format step to the Zap.

You can adjust for time zones.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J

The time zones are correct, here is the diff between google and zoho: 

Google Calendar: start: dateTime: 2024-02-09T18:00:00-05:00

Google Calendar end: dateTime: 2024-02-09T19:00:00-05:00

Zoho Calendar: start: 20240209T080000-0500

Zoho Calendar end: 20240209T090000-0500

ken.a
Userlevel 7
Badge +6

Hi there @JamesLMartin,

It looks like you’ve reached out to our Support Team about this and they replied today with a suggestion. I’ll share details of the suggestion here in case it’s helpful:

From what you've described, it sounds like the issue you're experiencing is with the time translation between Google Calendar and Zoho Calendar events. I understand how frustrating this can be, especially when dealing with important calendar events.

Based on the data you've provided, it appears that the time is being incorrectly converted to AM instead of PM when events are created in Zoho Calendar. I believe this could be due to the timezone settings between the two apps.

To help resolve this issue, I suggest checking the timezone settings in both your Google Calendar and Zoho Calendar to ensure they're identical. You can read more about this here: https://help.zapier.com/hc/en-us/articles/8496215472653-Zap-dates-or-times-are-incorrect. 

After you've done this, please try triggering the Zap again and see if the time on the Zoho Calendar event aligns correctly with the Google Calendar event.

Really appreciate your patience here. Looking forward to hearing back from you. Thanks!

If you’ve got any questions regarding their suggestion it would be best to continue the conversation with them over email. If you can’t locate their reply I’d recommend searching your spam/junk folder or searching your inbox for any emails from zapier.com in case. Sometimes their emails can end up in the spam/junk folder by accident.

J

I had originally checked that and the time zones are correct. I did notice that there was a difference in the format of the time zone: 5:00 v/s 500.  Will that make a difference? and if so, how can this be resolved? 

Google Calendar: start: dateTime: 2024-02-09T18:00:00-05:00

Google Calendar end: dateTime: 2024-02-09T19:00:00-05:00

Zoho Calendar: start: 20240209T080000-0500

Zoho Calendar end: 20240209T090000-0500

J

You can see in the data that the time zones are the same, correct?

ken.a
Userlevel 7
Badge +6

Hi @JamesLMartin,

I’d recommend relaying this information with our Support Team since they have the correct tools to look closer at the Zap and its logs to determine the cause of the issue.

I appreciate your patience and understanding.

B

Experiencing the exact same issue. Not likely relevant, but maybe so: we’re also in the GMT-5:00 timezone. Trying a sync between Arlo events and Zoho calendar, every entry appears as if the first digit was truncated, just like JamesLMartin described. Confirmed our timezone settings are correct on both ends, and added a default time zone in case.

We’ve also set a default timezone in Zapier - if I recall, it’s described something like “time zone to use if we cannot read / discover embedded timezones from apps.”

Going to reach out to Zapier support, and wanted to add the record here for future visitors.

B

 

 @JamesLMartin have you resolved this issue? Just contacted tech support and received a reply saying “a bug report was filed, but we don’t know when it will be investigated.” So at this point, there’s not even a confirmation that this is a Zapier quirk. I’m wondering if this is a Zoho thing, so that’s the next item I plan to investigate… any updates from your end are appreciated.

B

I just tried doing a sync to Google Calendar instead Zoho Calendar. What should have been added as 17:10 was created as 07:10… so it again looks like the first digit was dropped. If this is a glitch, it now really appears that it’s introduced when getting processed by Zapier.

SamB
Rank
Userlevel 7
Badge +11

Hi @JamesLMartin and @Bytech! 

I checked on the bug report Bytech mentioned and it appears that Zoho’s developers have been able to identify the cause of the issue and are working on getting a fix in place.

I’m unable to share any details on when you can expect a fix to be implemented by but you’re both on the list on folks being impacted by this issue so you’ll receive an email notification from us as soon as it’s resolved.

Thanks for your patience in the meantime! 🙂

Reply


Terms & Conditions