Others

Fix Microsoft Lists View Returning No Results with Calculated Date

Chanuka Geekiyanage Oct 22, 2026 869 views

Question details

The user needs to fix a Microsoft Lists view that displays zero items when filtering a calculated date column using a dynamic condition.

How to Fix Microsoft Lists View Returning No Results with a Calculated Date

Product: Microsoft Lists / SharePoint Online
Device & OS: not provided
Scenario: Filtering a list view with a formula like [Today]+30 against a calculated column used for tracking hire dates and years of service.
Observed behavior: The filtered view returns absolutely no items, even though there are records that theoretically match the logical date criteria.

Before you start

Ensure you have List Owner or Edit permissions in Microsoft Lists or SharePoint to modify view settings and adjust calculated column formulas.

Solution 1Recommended

Verify Exact Date Matching and Data Types

Ensure the calculated column outputs a pure date type without hidden time values, which often break exact match filters.

A calculated date must perfectly match the view filter value to return results. If the calculation inadvertently stores a time component, a filter using exactly [Today]+30 will fail to find a match.

Access List Settings

Click the gear icon in the top right corner of your Microsoft List and select 'List settings'.

Edit the Calculated Column

Scroll down to the Columns section and click on your calculated date column. Verify that 'The data type returned from this formula is' is strictly set to 'Date and Time' and 'Date Only'.

Review the View Filter

Navigate back to your list, edit the current view, and check your filter. Ensure the criteria exactness matches the data—if the data has time elements, an exact 'is equal to' [Today]+30 will not work.

Verify Exact Date Matching and Data Types

Time Stamp Discrepancies: SharePoint calculates [Today] based on the server's time. Even minor time differences will cause an 'is equal to' filter to fail when time data is present.

Solution 2

Test with Broadened View Filters

Change the strict equality filter to a date range to determine if the issue is a strict date/time mismatch.

Solution 3

Use Power Automate with a Standard Date Column

Bypass calculated column limitations by using a standard date column updated dynamically via Power Automate.

Free Microsoft Office alternative

Manage Data and Dates Easily with WPS Spreadsheet

If complex Microsoft Lists calculations and SharePoint view filters are slowing you down, consider managing your tracking sheets and employee data in WPS Spreadsheet. It offers a lightweight, highly compatible environment for organizing tabular data without strict backend server limitations.

Fully compatible with Microsoft Excel (.xlsx) formats for easy data migrationUse TODAY() and dynamic date filters without complex server-side view issuesFree and lightweight alternative to heavy Microsoft Office suitesFamiliar user interface with zero learning curve for spreadsheet users

microsoft office alternative - wps office

Frequently Asked Questions

Why does [Today] work in default columns but fail in calculated columns?

Microsoft Lists restricts using dynamic functions like [Today] or [Me] directly inside calculated column formulas. While they can sometimes be used in view filters against those columns, discrepancies in backend timestamps often cause exact-match failures.

How do I correctly filter a Microsoft List by an exact number of days from today?

In your view settings, set the filter target to your Date column, select the 'is equal to' operator, and type [Today]+30 (or your desired number of days). Ensure the target column is strictly formatted as a Date without the Time component.

Can I use spreadsheets instead of Microsoft Lists to track employee anniversaries?

Yes. Spreadsheets natively handle dynamic date calculations like =TODAY()+30 and allow for immediate filtering. WPS Spreadsheet is an excellent, format-compatible tool for tracking dates, employee anniversaries, and service years without complex list setups.

Office Quick Solutions