Question

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

  • 9 February 2024
  • 11 replies
  • 31 views

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


11 replies

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.

 

 

 

 

Userlevel 7
Badge +14

@JamesLMartin 

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

You can adjust for time zones.

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

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.

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

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

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.

Reply