Skip to main content
FLO.W 思流Notion Formulas
Back to function index

dateBetween

A quick reference for the Notion dateBetween function, including syntax, purpose, return value, and examples.

Quick reference

ItemDetails
FunctiondateBetween()
CategoryDate and time
SyntaxdateBetween(date1, date2, unit)
PurposeDifference between two dates
Return valueNumber

Official example of the dateBetween function in the Notion formula editor

Examples and notes

dateBetween(prop("Due Date"), today(), "days")

A common due-date status formula:

lets(  daysLeft, dateBetween(prop("Due Date"), today(), "days"),  ifs(    empty(prop("Due Date")), "No due date set",    daysLeft < 0, "Overdue " + format(abs(daysLeft)) + " days",    daysLeft == 0, "Due today",    daysLeft == 1, "Due tomorrow",    daysLeft <= 7, "7 Due within days",    "Not due yet"  ))

To use these formulas directly in task reminders, project progress, note heatmaps, and reports, continue with FLO.W Notion Template.

Back to function index

Last updated on

Table of Contents

Quick reference
Examples and notes
Related functions