How to work with dates in Notion
Notion uses a specific date format called ISO 8601, which includes the:
It can also optionally include:
- Timezone offset.
When you use a Notion date field in Zapier, Zapier will try to convert your provided date to this format. However, if you are inputting a date, time, and timezone into a date field, Zapier recommends using Formatter to modify the date format.
How Zapier settings can affect dates
To avoid any confusion, Zapier recommends setting the timezone in either your Zapier account or Zap to match the timezone you set up in your Notion account. This will ensure your dates are read correctly and a timezone offset will automatically be applied when interacting with a date field.
Search for a database item by a date field
When searching for a database item by a date field using the Find Database Item action, Zapier expects to read the time and timezone associated with a date, based on your Zapier account.
This can have unintended consequences when searching for a date only.
To override Zapier’s default time and timezone setting for Notion date fields, you can add the time format
T00:00-0000 to the date field you are searching. This represents 12:00am in UTC and ensures that only the date is considered in the search.
My databases are not listed in the dropdown menu
- Check that Zapier has permission to access your database in Notion.
- If the database you're looking for is a subpage, un-nest it, and temporarily make it a page. After the Zap finds it, you can change it back to a subpage.
- Create a new app account connection to Notion.
When creating a database item, I’m getting an error about an invalid option
I can't see all fields in my Zap
- Files and media
My Zap is triggering too much
I'm not seeing content appear in my Zap
When using either the New Database Item trigger or Find Database Item action, it’s not expected behavior that your Zaps will show you data from your content block.
Let us know in this Community thread if you want to be notified when this is available.
My Zap doesn’t trigger from updates made to my content
Unexpected error: !DOCTYPE html
- Waiting for a few minutes. This type of error usually resolves itself. You can also check Notion’s status page to see if the app has an outage that could affect your Zap.
- Replay failed Zap runs.
I gave Zapier full access to all of my pages, but new pages don’t appear