Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Question

Issue with start date/time on Google sheets to Outlook calendar

  • August 8, 2024
  • 3 replies
  • 24 views
E

I have a zap that bulk adds events on outlook calendar when a row is added on Google sheets. everything except the start/end date & time works. I have date as a column in the format dd/mm/yy and time as a separate colum, and tried the formating with hh:mm am/pm timezone and without the timezone too.

I am in Australia and use +10GMT (AEST or AEDT)  as the timezone.

My test plled this trigger: 9/10/24 (start and end) and time was formated as 09:00:00

The action was for some reason made the event 11 September, midnight to 1am  (GMT+10/AEST).

Is there anyway I can format those coulums so that when in translates to outlook it matches what i have

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

3 replies

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • August 8, 2024

Hi there @EEC,

Welcome to the Community! 🎉

Before we dig deeper into this, would you mind sharing a detailed screenshot of how your Zap is configured? Also, please share a screenshot of the “Action” section of your action step that shows all of its fields. Like so:

46dd6c0979e3d815d621b8da43084ef1.png
(view larger)

Please don't include personal information in the screenshot, or be sure blur out any personal information.

Thanks!

E
  • EECBeginner
  • Author
  • Beginner
  • August 8, 2024

Below is the zap, action, test result for date and time(s) and the realtime result. You can see that I worked out that if i format my google sheet date and time in ISO format, that dates works but the following occurs:

If I use T and Z (eg. ...T09:00Z) it comes out perfectly in the test but b/w the test and the output it adds 10 hours - so the event is made at 19:00.

Below I tried L and Z (...L09:24Z) - and it comes as T01:24:00Z, which equals for some reason 11:24 on outlook.

 

ken.a
Forum|alt.badge.img+6
  • ken.aZapier Staff
  • Zapier Staff
  • August 12, 2024

Hi @EEC,

Could you please try using the Date/Time Formatter action and use the “Format” option and format the date and see if it’ll fix the date formatting issue?

99b7933e9af5a3a94eabe9832d2870b2.png
(view larger)

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Terms & ConditionsAccessibility statement