SharePoint Document Issues

How to Fix Duplicate Created Dates in SharePoint Filters

Maira MehtabMaira Mehtab Oct 21, 2026 868 views

Question details

Users encounter duplicate date entries with minor formatting discrepancies when filtering the Created column in SharePoint.

Fixing Duplicate Created Dates in SharePoint Filters
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Filtering a list or document library by the Created date to find specific files or list items.
Observed behavior
The filter dropdown displays duplicate dates. One date is formatted correctly, while another includes a leading space before the month, making filtering unreliable.
Before you start

Ensure you have at least Edit or Full Control permissions for the affected SharePoint list or library, as you will need access to the library settings to modify column properties.

Solution 1Recommended

Toggle the Created Column Display Format

Temporarily changing the column's date format forces SharePoint to refresh its indexing and display, which often clears out formatting glitches like leading spaces.

SharePoint occasionally experiences caching or indexing bugs that cause default system columns, like the 'Created' date, to display inconsistently in filter menus. Toggling the display format from Standard to Friendly, and back again, triggers a backend refresh.

1
Access Library Settings

Navigate to your SharePoint list or document library. Click the Gear icon (Settings) in the top right corner and select 'List settings' or 'Library settings'.

2
Edit the Created Column

Scroll down the settings page to the 'Columns' section. Find and click on the 'Created' column to open its properties.

3
Change Format to Friendly

Under the 'Column Settings' or 'Display Format' options, change the format from 'Standard' to 'Friendly' (which displays dates like 'yesterday' or 'about an hour ago'). Click OK to save the changes.

4
Test and Revert

Return to your list or library and test the filter dropdown to see if the duplicate dates are gone. If resolved, go back to the settings and change the format back to 'Standard' if that is your preferred display.

Toggle the Created Column Display Format
Persistent Issues: If toggling the format does not resolve the leading space bug, this may be a tenant-level indexing issue. In this case, your SharePoint administrator should create a Microsoft 365 support ticket for the development team.
Free Microsoft Office alternative

Try WPS Office for Seamless Document Management

While SharePoint list issues require Microsoft's backend support, your daily document handling doesn't have to be complicated. WPS Office provides a free, lightweight, and highly compatible suite for all your word processing, spreadsheet, and presentation needs, allowing you to easily view, edit, and manage files offline or in the cloud.

Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) for seamless sharing.Lightweight installation with a familiar, easy-to-use tabbed interface.Built-in robust PDF editing and conversion tools at no extra cost.Completely free alternative with cross-platform support for Windows, Mac, Linux, and mobile.
microsoft office alternative - wps office

Frequently Asked Questions

Why does a leading space appear in my SharePoint date filter?

This is typically a known formatting glitch related to SharePoint's internal indexing or a mismatch in regional settings. It causes the system to read the same date string differently, separating them into two filter options.

Can I manually delete or merge the duplicate date in the filter list?

No, filter dropdown values are automatically generated by SharePoint based on the items in the list. You cannot manually edit the filter list itself. You must refresh the column settings to force the system to consolidate the dates.

How do I create a Microsoft 365 support ticket for this issue?

If you are an administrator, log into the Microsoft 365 Admin Center, click on 'Show all', select 'Support', and then 'Help & Support'. From there, you can describe the issue and open a new service request.