Date (Data Type)
Learn about the Date data type in Notion formulas.
Underneath the hood, Notion's date object consists of three parts:
- Start date
- End date (optional)
- Time zone
You can learn more about how dates are formatted under the hood at the Notion API's property value reference for dates:
The following Notion property types output (or can output) date objects:
- Created time
- Edited time
- Rollup (if set to rollup a property outputting a date object, and not set to "show original")
- Formula (if the formula is outputting a date object)
Notion sets it time zone automatically based on the system's time zone.
Depending on the property and/or formula function that is outputting the date object, you can get different results.
The diagram below shows the same Notion database viewed from two different time zones (this was accomplished by setting my system time to a different time zone, then refreshing the page). You can also view the diagram full-screen on Whimsical.
View and duplicate an example database with all of these date objects:
Date properties with set times always display those times in the time zone in which they were set.
If you don't specify a time zone manually, then the time zone won't show for you when you're in that time zone; however, users in other time zones will see the time zone displayed along with the date.
Note how the second row does not display
(MDT)at first. When the system time zone is changed, that row now displays
(MDT), and the set time (8:00am) is not changed to reflect the system's new time zone.
This behavior is reflected in the Date (Formula) property, which simply referenced the Date property:
However, things are different when dates are derived from a timestamp. The date objects created from the fromTimestamp function - as well as the now function - are always displayed in the local time zone's time. In these instances, this behavior cannot be changed, and an alternate time zone cannot be specified.
It is also very difficult to perform date comparisons using the output of
formatDate(). While equality comparisons work well:
formatDate(now(), "MMM DD YYYY") == formatDate(prop("Date"), "MMM DD YYYY")
...it is much more difficult to perform "earlier than" or "later than" comparisons.
My name is Thomas Frank, and I'm a Notion-certified writer, YouTuber, and template creator. I've been using Notion since 2018 to organize my personal life and to run my business and YouTube channel. In addition to this formula reference, I've created a free Notion course for beginners and several productivity-focused Notion templates. If you'd like to connect, follow me on Twitter.