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 Asked & Answered 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.

Best answer

Date Issue with Zapier Table When Integrating with Notion

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?

Best answer by Troy Tessalone

@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

View original
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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • May 9, 2024

Hi @tetricode 

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

⚡ Troy Tessalone - AutomationAce.com | Top Zapier Solution Partner | #1 Zapier Community Contributor

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • Answer
  • May 9, 2024

@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 | Top Zapier Solution Partner | #1 Zapier Community Contributor

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

Early access


Next Gen Zaps

Build and deploy automations from AI tools you already use. With Agentic Management, if anything breaks, the agent diagnoses the issue and proposes a fix.

Request access now


Terms & ConditionsAccessibility statement