Notion databases store a wide variety of information, and filtering by date range helps you focus on tasks, events, or records that fall within a specific period. This is useful for project planning, sprint reviews, or tracking deadlines. The filter feature in Notion allows you to set conditions based on a Date property, including options like “On or after” and “On or before” to define a range. This article explains how to apply date range filters, how to use advanced filter logic, and what to watch out for when working with date properties.
Key Takeaways: Filtering a Notion Database by Date Range
- Filter menu > Add a filter > Date property: Apply a date range using conditions like “On or after” and “On or before” together.
- Filter logic group set to “And”: Combine two date conditions to create a range instead of using a single “Is within” option.
- Date property must exist: Only database views with a Date property column can use date range filters; add one if missing.
What Is a Date Range Filter in Notion?
A date range filter limits the rows shown in a Notion database view to those whose Date property falls between two dates. For example, you can show only tasks with a due date between January 1 and January 15. Notion provides several filter conditions for Date properties: “Is exactly”, “Is before”, “Is after”, “Is on or before”, “Is on or after”, “Is empty”, and “Is not empty”. To create a range, you must use two filter conditions combined with the “And” logic. The “Is within” condition is a shortcut for a predefined range like “Past 7 days” or “Next month”, but it does not allow custom start and end dates. For a fully custom range, you need to add two separate filters.
Before filtering, your database must have a column with the Date property type. If you do not have one, add a new property and set its type to Date. You can then enter dates manually or use Notion’s date picker. The filter works on all database views: table, board, calendar, gallery, list, and timeline. However, the filter is view-specific; each view can have its own set of filters.
Steps to Filter a Notion Database by Custom Date Range
Follow these steps to apply a custom date range filter in a Notion database view. The example uses a table view, but the process is the same for all view types.
- Open the database view
Navigate to the page that contains the database. Click on the view tab where you want to add the filter. If you want to keep the original view unchanged, create a duplicate view first by clicking the view name and selecting “Duplicate”. - Click the Filter button
In the top-right area of the database, locate the Filter button. It appears as a funnel icon or the word “Filter” next to the Sort and Search buttons. Click it to open the filter panel. - Click “Add a filter”
In the filter panel, click the “Add a filter” button. A new filter row appears with a property selector and a condition dropdown. - Select your Date property
Click the property selector (it shows “Select a property” by default) and choose the Date property you want to filter on. For example, “Due Date” or “Event Date”. - Set the first condition to “On or after”
Click the condition dropdown and select “On or after”. Then click the date field and pick the start date of your range. For example, January 1, 2025. - Click “Add a filter” again
With the first filter active, click “Add a filter” once more. A second filter row appears below the first. - Select the same Date property
In the second filter row, choose the same Date property you used in the first filter. - Set the second condition to “On or before”
Click the condition dropdown and select “On or before”. Pick the end date of your range, for example, January 15, 2025. - Verify the filter logic is set to “And”
Look between the two filter rows. You will see a dropdown that says “And” by default. If it says “Or”, click it and change it to “And”. This ensures both conditions must be true for a row to appear. - Close the filter panel
Click outside the filter panel or press Escape. The database view now shows only rows where the Date property is on or after the start date and on or before the end date.
Common Mistakes and Limitations When Filtering by Date Range
The filter shows no results even though dates exist in the range
This usually happens when the Date property contains time values that fall outside the range. For example, a date of January 15, 2025 at 3:00 PM is after January 15, 2025 at 12:00 AM. To fix this, set the end condition to “On or before” and use the date picker to include the full day. Alternatively, use a formula property to strip the time from the date. Another cause is that the filter logic is set to “Or” instead of “And”. Check the dropdown between the two filters and confirm it says “And”.
The filter uses “Is within” but I need a custom range
The “Is within” condition offers presets like “Today”, “This week”, “Next month”, or “Last 30 days”. These are convenient for relative ranges, but they do not let you pick exact start and end dates. To set a custom range, always use two separate filters with “On or after” and “On or before” combined with “And”.
The filter applies to the wrong view
Filters in Notion are view-specific. If you filter one view, other views remain unchanged. If you want the same filter on multiple views, you must add the filter to each view individually. To save time, duplicate a view that already has the filter and rename it.
The Date property is missing from the database
Without a Date property, you cannot filter by date range. Add a new property by clicking the “+” button in the database header, selecting “Date” as the property type, and naming it. Then populate the dates for existing rows.
Filtering by date range in a linked database
Linked databases (synced copies of another database) support the same filter options. However, the Date property must exist in the original database. If the property is missing there, add it to the source database first. Filters on a linked database do not affect the original.
Notion Filter Conditions for Date Properties: Comparison
| Condition | Behavior | Use Case |
|---|---|---|
| Is exactly | Shows rows where date matches a specific day exactly | Filter for a single known date |
| Is before | Shows rows with a date earlier than the chosen date (exclusive) | Find items due before a deadline |
| Is after | Shows rows with a date later than the chosen date (exclusive) | Find items starting after a certain day |
| Is on or before | Shows rows with a date on or earlier than the chosen date (inclusive) | Used with “On or after” to create a custom range |
| Is on or after | Shows rows with a date on or later than the chosen date (inclusive) | Used with “On or before” to create a custom range |
| Is empty | Shows rows where the Date property has no value | Find items missing a date |
| Is not empty | Shows rows where the Date property has any value | Exclude items without a date |
| Is within | Shows rows within a predefined relative range (Today, This week, etc.) | Quick filtering without custom dates |
This table covers all standard conditions for Date properties in Notion as of 2025. Notion does not support a native “Between” condition, so the two-filter method is the only way to create a custom range.
You can now filter any Notion database by a custom date range using the two-filter technique with “On or after” and “On or before” conditions. To refine further, combine the date filter with other property filters, such as a Select property for status. For recurring date ranges, consider using Notion’s formula property with the dateBetween() function to calculate durations or highlight upcoming items.