SharePoint Document Issues

How to Filter a SharePoint List by Start and End Date

Aamir Naveed Akram Sep 27, 2026 871 views

Question details

The user wants to create a custom SharePoint list view that filters and displays items falling within a specific date range, such as between a 'Tuesday Before' start date and a 'Meeting Date' end date.

How to Filter a SharePoint List by Start and End Date

Product: SharePoint
Device & OS: not provided
Scenario: Customizing a SharePoint list view to display only the records that occur within a defined timeframe by setting multiple date filter conditions.
Observed behavior: Items meeting the date criteria are not appearing in the view. This is often caused by improperly configured filter conditions or calculated date columns being formatted as text instead of Date/Time values.

Before you start

Ensure you have the necessary site permissions to create or edit list views in your SharePoint environment. Additionally, verify that your date columns are formatted strictly as 'Date and Time' rather than 'Single line of text', as text formatting will prevent chronological filtering.

Solution 1Recommended

Configure the Date Range Filter in List Settings

Use this method to apply the correct 'greater than or equal to' and 'less than or equal to' rules in your SharePoint view settings.

To filter items successfully between two dates, you must apply dual conditions linked by an 'And' operator. This ensures SharePoint only retrieves records that satisfy both the start and end date boundaries.

Navigate to List Settings

Open your SharePoint list, click the Gear icon (Settings) in the top right corner, and select 'List settings'.

Select the Target View

Scroll down to the 'Views' section at the bottom of the settings page and click on the specific view you want to modify (e.g., 'All Items' or a custom view).

Configure the Start Date Condition

Scroll down to the 'Filter' section. Select 'Show items only when the following is true'. In the first column dropdown, select your date column (e.g., Meeting Date). Set the operator to 'is greater than or equal to' and enter your start date criteria.

Configure the End Date Condition

Click 'And' for the subsequent rule. Select the relevant date column again, set the operator to 'is less than or equal to', and enter your end date criteria.

Save the View

Scroll to the top or bottom of the page and click 'OK' to save your changes. Return to your list to verify the filtered results.

Configure the Date Range Filter in List Settings

Dynamic Filtering: You can use the [Today] parameter in the filter value boxes to create dynamic rolling date ranges based on the current date.

Solution 2

Fix Calculated Column Formatting Issues

Use this solution if your date filter still fails, which usually happens when calculated date columns are accidentally converted to text strings.

Free Microsoft Office alternative

Manage Exported SharePoint Data with WPS Office

While SharePoint list views are managed on the web, complex data filtering and reporting are often easier in a spreadsheet. Export your SharePoint list and open it in WPS Office—a free, lightweight alternative to Microsoft Office that offers powerful spreadsheet capabilities and full compatibility with exported Excel files.

1. Export Your SharePoint List: In your online SharePoint list, click 'Export' from the top ribbon and select 'Export to Excel'.
2. Open with WPS Spreadsheet: Launch WPS Office, select 'Spreadsheet', and open the downloaded .xlsx or .iqy file.
3. Apply Custom Date Filters: Select the headers of your date columns, navigate to the 'Data' tab, click 'AutoFilter', and use the 'Date Filters' dropdown to specify your exact start and end date range.

Fully compatible with Microsoft Excel (.xlsx) formats exported from SharePointAdvanced AutoFilter capabilities for effortlessly sorting complex date rangesFree and lightweight suite requiring minimal system resourcesFamiliar spreadsheet user interface for a seamless migration

microsoft office alternative - wps office

Frequently Asked Questions

Why is my SharePoint list filter hiding items that should be visible?

This usually occurs if the column being filtered is formatted as a 'Single line of text' rather than 'Date and Time'. It can also happen if a calculated column is returning text values. Check your List Settings > Columns to ensure the proper data types are applied.

Can I filter a SharePoint list to show only items occurring in the future?

Yes. In the List View filter settings, select your date column, choose 'is greater than' as the operator, and type [Today] in the value field. This will dynamically filter the list to show only dates after the current day.

How do I filter between two specific dates in SharePoint?

In your view settings under Filter, choose 'Show items only when the following is true'. Set the first rule to '[Your Date Column] is greater than or equal to [Start Date]'. Then, click the 'And' operator, and set the second rule to '[Your Date Column] is less than or equal to [End Date]'.

Document & File Issues