⏳ dateBetween Function
If you’re looking forward to a particular date and want to create a property that returns length of time between now and then inside Notion, use the dateBetween function. This function is also useful for creating conditions based on deadlines.
Basically, ‘dateBetween’ is exactly what it says on the tin - return amount of time between two specified dates. In the example below, the specified dates are upcoming holidays and today’s date.
The Formulas
Months Left: dateBetween(prop("Date"), now(), "months")
Weeks Left: dateBetween(prop("Date"), now(), "weeks")
Days Left: dateBetween(prop("Date"), now(), "days")
Hours Left: dateBetween(prop("Date"), now(), "hours")
Minutes Left: dateBetween(prop("Date"), now(), "minutes")
The Breakdown
dateBetween: Call function
(prop("Date"),: Between property Date …
now(),: And today’s date …
"months"): Return number of months