📅 Filter Dates 101
There are several ways to filter and sort Notion databases by dates. The following formulas and filters can help a user create unique database views for entries. For example, filtering dates by the current week , by the current month, and by the current quarter. Formulas like this are necessary when filters alone don’t work. Here is how it works.
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.
Click to expand
Today Formula
formatDate(prop("Date"), "MMM D, YYYY") == formatDate(now(), "MMM D, YYYY")
Current Week (M-Su)
Current Week (Su-Sa)
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.
Lastly, sort the view as Date Ascending to arrange the dates in chronological order.
Notion can be used for simple and complex financial planning and tracking. For instance, using some important formula tricks, you can manipulate date and number properties to project the approximate end to a savings goal. The following use-case is a great addition to any personal finance Notion dashboard. Here’s how it works.
Build a Notion dashboard with a single formula. This setup is designed for users who want a read only dashboard to compartmentalize deadlines in three different views: Tasks for today, Tasks this week, and Tasks for later. These views use Notion features like Timeline, Boardview, Grouping, Formula, and Math Block.
Create a Twitter thread editor inside of Notion with the formula property and new grouping feature! Creating, planning, and analyzing thread performance can be done inside a single minimal Notion database. Below is how it works, a character limit formula, and a link to a free Twitter thread editor template.
Thoughtful prioritization is the practice of assigning precise conditions to a priority level. Every priority level describes the difficulty, urgency, and impact of a task. Essentially, if you are using a priority tag property inside Notion, here is a formula to help systematize priority assignment with precise conditions.