Solved: Creating a dynamic date range filter in Notion using a formula that compares a Date property to the current week's rolling boundaries

📌 The Problem Explained

In Notion, the built-in “Date” filter allows you to select “This week,” but it is often rigid and relies on the calendar week (Sunday to Saturday). Many professionals require a rolling boundary—such as a strict Monday-to-Sunday window—or need a logic-based filter that can be combined with other complex criteria in a single formula.

Users often find themselves manually updating filters every Monday morning or struggling with the “Within” filter options when they want a “True/False” checkbox to drive a more complex dashboard view.

💡 The Quick Solution

To determine if a date falls within the current rolling week (Monday-Sunday), create a Formula property and use the following code:

dateStart(prop("Date"), "week") == dateStart(now(), "week")

Note: Replace prop("Date") with the exact name of your date property.

🛠️ Step-by-Step Breakdown

Step	Action	Description
1	Add Property	Open your database, click the + icon to add a new property, and select Formula.
2	Name the Formula	Label the property “This Week?” or “Current Week Filter.”
3	Insert Logic	Click the property cell and paste: dateStart(prop("Date"), "week") == dateStart(now(), "week").
4	Verify Boolean	The formula will return a checked box if the date is in the current week and unchecked if it is not.
5	Apply Filter	Click Filter at the top of your database, select your new formula property, and set it to Checked.
6	Hide Property	Click the property header and select Hide in view to keep your database clean.

⚠️ Common Mistakes to Avoid

• Property Name Mismatch: Notion formulas are case-sensitive. If your date column is named “Deadline,” the formula must read prop("Deadline"). If you use the modern Formula 2.0 editor, you can simply click the variable in the suggestions list.
• Timezone Displacement: If you work late at night, a date might “flip” to the next week early if your Notion workspace and computer timezones are not synced. Check Settings & members > Language & region to ensure your timezone is correct.
• Defining the Start of Week: By default, Notion uses your local settings to determine if the week starts on Sunday or Monday. If the rolling boundary feels “off” by one day, check your Language & region settings to toggle the Start week on Monday preference.