Skip to main content
Best answer

Correcting Outlook event times when using Pretty Date/Time in Zapier

  • December 16, 2024
  • 4 replies
  • 35 views

Forum|alt.badge.img+1

Not sure how to put this in a work queue for someone, but using the “Pretty” date/time to create in Outlook was generating the wrong meeting times.

 

How I realized this: I’m using Create Event from the Outlook zap in a process.  When I am using GCal as a source (to replicate across calendars), the tool is shifting the meeting 2 hours earlier consistently.  My calendars are set to PST:

and 

… which is what I originally thought would be the problem.

 

But if I look at the creation step, data in vs data out, it’s off.  The original meeting is thus:

… and the action is setting the meeting with:

and 

Which is an incorrect calculation of UTC-->PST.

What I realized was that using the “Pretty Date/Time” as the source (which I believe is the default) was being incorrectly rendered into UTC.  Changing the source to be the UTC date/time corrected this issue.

Best answer by Troy TessaloneBest answer by Troy Tessalone

@smackafee 

Check the Time Zone of your Apps. (Gmail/Outlook)

Check the Time Zone of your Zap in the Details. (screenshot)

Check the Time Zone of your Zapier Account: https://zapier.com/app/settings/profile

 

Help: https://help.zapier.com/hc/en-us/articles/8496215472653-Zap-dates-or-times-are-incorrect

 

 

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31068 replies
  • December 16, 2024

Hi ​@smackafee 

For us to have more info, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible.


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 11 replies
  • December 17, 2024

You mean this?

 


Troy Tessalone
Forum|alt.badge.img+14
  • Zapier Expert
  • 31068 replies
  • Answer
  • December 17, 2024

@smackafee 

Check the Time Zone of your Apps. (Gmail/Outlook)

Check the Time Zone of your Zap in the Details. (screenshot)

Check the Time Zone of your Zapier Account: https://zapier.com/app/settings/profile

 

Help: https://help.zapier.com/hc/en-us/articles/8496215472653-Zap-dates-or-times-are-incorrect

 

 


Forum|alt.badge.img+1
  • Author
  • Beginner
  • 11 replies
  • December 17, 2024

That certainly would help it translate better.  It’s odd that one direction worked fine and the other didn’t, but I didn’t check the sources for the direction that was operating fine.  Thanks!