The following formula calculates the difference in days of a Notion object:
dateBetween(now(), prop("Created"), "days")
dateBetween
: Calculates the difference between two dates.now()
: Returns the current date and time.prop("Created")
: References the “Created” property."days"
: Specifies that the difference should be calculated in days.
I use this as a property of many of my Notion objects. To do this:
- Create a new property: Add a new property to your database and name it “Days Since Creation.”
- Set the property type to “Formula.”
- Paste the formula: Enter the formula
dateBetween(now(), prop("Created"), "days")
into the formula editor.