How to Fix Duplicate Created Dates in SharePoint Filters
Question details
Users encounter duplicate date entries with minor formatting discrepancies when filtering the Created column in SharePoint.

- 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.
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.
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.
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'.
Scroll down the settings page to the 'Columns' section. Find and click on the 'Created' column to open its properties.
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.
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.

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.

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.




