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

Date Issue with Zapier Table When Integrating with Notion

T

Hello! I'm using Zapier and have encountered an issue with date formats while integrating it with Notion.

I am currently using the YY:MM:DD format for dates, and my timezone is set to Asia/Seoul. Both of these settings are configured correctly in both my Zap and the Zapier table fields.

However, when I update a date in the Zapier Table, such as converting the date (Ex) 2024-05-05 to match the format and timezone, it gets recorded as 2024-05-04. The date is reduced by one day when it's entered.

Is this a known issue with Zapier tables?

icon

Best answer by Troy Tessalone 9 May 2024, 04:48

View original

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @tetricode 

Try using a Formatter > Date & Time > Format step to adjust the time zones.

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

Hi @Troy Tessalone !

I've already set both Timezone and Format the same through the format.
Both Zapier and Zapier table are set to YY:MM:DD format and Asia/Seoul Timezone.

Why is the date reduced by one day?

Troy Tessalone
Userlevel 7
Badge +14

@tetricode 

Zapier Tables may be expecting a timestamp in UTC time zone.

 

Or you can try opening a ticket with Zapier Support: https://zapier.com/app/get-help

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

@Troy Tessalone 
Thank you!
I will try opening a ticket!

Reply


Terms & Conditions