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

View Example In Notion