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

Notion item has wrong date when created from New row in sheets

  • 24 August 2023
  • 4 replies
  • 640 views
markkoeks
Userlevel 1

I have a zap that listens for a new row and creates a database item in Notion. However, the date is different in Notion (-1d) than it is logged in Sheets. See attached. I feel like this is time zone related but not sure where I would edit this. When I tru to format the date in Zapier, I’m formatting the correct date “2023-09-01” which tells me something is getting messed with the transfer to Notion. 

 

Any ideas?

 

icon

Best answer by GetUWired 24 August 2023, 14:22

View original

4 replies

markkoeks
Userlevel 1

This happens for all zaps - the Notion date is -1day. It’s not unique to the 2023-09-01

GetUWired
Userlevel 7
Badge +12

Hi @markkoeks,

Yes, this looks like it may be a timezone issue.  

First, I would recommend playing around with the timezone and format in your Formatter step.

I imagine UTC might be the timezone it is defaulting to.  

If this is happening every single time you put in a date, you could use an Add/Subtract Time Formatter step to add 1 day as a workaround.

Hope this helps!

markkoeks
Userlevel 1

Thanks @GetUWired  - it’s extra actions but at least it works 👍

SamB
Rank
Userlevel 7
Badge +11

Thanks for confirming that worked, @markkoeks. Really pleased to see GetUWired’s suggestion helped to get this solved! 😁🎉

Sounds like you're all sorted for the moment, but please do reach out in the Community again if something new pops up. We love helping out! 🤗

Reply


Terms & Conditions