Notion Tip: Checkbox If Date Is Today And Remain Checked

☑️

Checkbox If Today

This little tutorial will solve a problem I stumbled upon inside the Notion reddit. A user asked how one can tick a checkbox based upon today’s date and to keep past dates ticked. The solution requires a combination of the formatDate and dateBetween functions.

Checkbox If Today

First, if you just want to checkbox if today, here is the formula:

formatDate(prop("Date"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY")

(Learn more about formatDate function here)

Checkbox Today and Remain Checked

dateBetween(prop("Date"), now(), "days") <= -1 or formatDate(prop("Date"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY")

Breakdown

(dateBetween(prop("Date"), now(), "days") <= -1

• If days between a date property and today is less than or equal to -1 …

or formatDate(prop("Date"), "MMM DD, YYYY") == formatDate(now(), "MMM DD, YYYY"))

• or if date is today …

View Example In Notion

---