How The Formulas Work

Each property determines if a single date falls within the current day, week (Mon-Sun), week (Sun-Sat), month, and quarter.

Today Formula

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

Current Week (M-Su)

formatDate(prop("Date"), "W") == formatDate(now(), "W")

Current Week (Su-Sa)

formatDate(prop("Date"), "w") == formatDate(now(), "w")

Current Month

formatDate(prop("Date"), "M") == formatDate(now(), "M")

Current Quarter

formatDate(prop("Date"), "Q") == formatDate(now(), "Q")

Filter Database Views

Filter a database view to show only the week, month or quarter with the formulas above and a filter.

Firstly, add a new database view.

Next, create a filter that shows the chosen formula property as true.

Lastly, sort the view as Date Ascending to arrange the dates in chronological order.

Here’s A Template Where I Use This

View An Example Inside Notion

Further Reading