SharePoint Document Issues

Fix Microsoft Lists Date Picker Missing When Editing Items

Elise Williams Sep 29, 2026 868 views

Question details

The date picker tool does not appear when attempting to edit an existing item in Microsoft Lists, preventing users from easily selecting dates.

Fix Microsoft Lists Date Picker Missing When Editing Items

Product: Microsoft Lists / SharePoint
Device & OS: not provided
Scenario: A user is trying to edit a date field for an existing list item, but the calendar pop-up (date picker) fails to load, even though it works fine for new items.
Observed behavior: The date picker works correctly in grid view and when creating new items, but is completely missing from the standard edit form when modifying existing items.

Before you start

Ensure you have the appropriate edit permissions for the Microsoft List and temporarily disable any browser extensions (such as ad blockers) that might interfere with SharePoint scripts.

Solution 1Recommended

Clear Browser Cache and Test Incognito Mode

Corrupted cached scripts and cookies can prevent Microsoft Lists interface elements like the date picker from loading properly.

Browser caches can sometimes hold onto outdated scripts after Microsoft pushes an update to SharePoint or Lists. Testing in a private window helps isolate whether the issue is cache-related.

Open a Private Window

Launch a new InPrivate (Edge) or Incognito (Chrome) window and log into your Microsoft Lists account.

Test the Edit Form

Select an existing item in your list, click 'Edit', and check if the date picker appears on the DateTime field.

Clear Cache and Cookies

If the date picker works in the private window, return to your normal browser window, go to settings, and clear cached data and cookies specifically for SharePoint and Microsoft domains.

Restart and Verify

Restart your browser and access your list normally to confirm the date picker is fully restored.

Clear Browser Cache and Test Incognito Mode

Solution 2

Check and Remove JSON Column Formatting

Custom JSON code applied to a DateTime column can unintentionally hide standard edit controls.

Solution 3

Use Grid View or Details Pane as a Workaround

Bypass the standard edit form bug by utilizing built-in alternative editing interfaces in Microsoft Lists.

Free Microsoft Office alternative

Manage Data Smoothly with WPS Office

If you frequently encounter interface bugs like missing date pickers in Microsoft Lists, consider using WPS Spreadsheet for managing complex lists and trackers. WPS Office is a lightweight, reliable alternative that offers seamless functionality and full compatibility with major Office file formats.

1. Export Your List: Export your Microsoft List to an Excel file using the 'Export' button on the command bar.
2. Open with WPS Spreadsheet: Launch WPS Office and open the downloaded file. You can easily sort, filter, and edit dates without missing interface controls.

Fully compatible with Microsoft Excel (.xlsx) formatsFree and lightweight alternative to Microsoft OfficeReliable built-in date and time picker functionsFamiliar user interface requiring no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Why does the Microsoft Lists date picker only work for new items but not existing ones?

This is often caused by an interface bug introduced during a Microsoft update, a corrupted browser cache, or specific custom JSON formatting (like 'inlineEditField') applied to the column that conflicts with the standard edit form layout.

How do I edit dates quickly if the main edit form is broken?

You can use 'Edit in grid view' located in the top menu of your list to make quick edits in a spreadsheet-like layout, or select the item and use the Details pane on the right side of the screen to change the date.

What should I do if removing JSON formatting and clearing the cache doesn't solve the problem?

If local troubleshooting fails, the issue is likely on Microsoft's server side. Check the Microsoft 365 Admin Center for service health alerts or contact Microsoft Support to report the bug.

Document & File Issues