Skip to main content

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?

Hi @tetricode 

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


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?


@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 
Thank you!
I will try opening a ticket!


Reply