Others

How to Fix SharePoint Date Field Showing Wrong or Stuck Date

Guest Writer Oct 10, 2026 869 views

Question details

Users need to correct SharePoint date fields and calculated columns that are displaying an incorrect or outdated current date.

How to Fix SharePoint Date Field Showing Wrong or Stuck Date

Product: SharePoint Online
Device & OS: not provided
Scenario: Using the TODAY() function or the 'Today's Date' default setting in SharePoint lists or calculated columns.
Observed behavior: The date field gets stuck or displays a date one or two days behind the actual current date, and clearing browser cookies provides only a temporary fix.

Before you start

Verify whether the incorrect date display affects multiple users in your organization and take note of the specific SharePoint lists and columns experiencing the issue before proceeding.

Solution 1Recommended

Submit a Support Ticket to Microsoft 365 Admin Center

Because this is a known back-end service issue affecting SharePoint Online, a Microsoft 365 administrator must contact Microsoft Support to investigate and resolve the bug on the server side.

The issue where the TODAY() function or 'Today's Date' setting shows an outdated date is often tied to a service-side bug within SharePoint Online. Since local troubleshooting steps like clearing browser cookies only offer temporary relief, the problem must be escalated to Microsoft's backend engineering team.

Log into the Admin Center

Have an individual with administrator privileges sign in to the Microsoft 365 admin center.

Navigate to Help & Support

Click on the 'Help & support' option located in the bottom right corner of the admin center dashboard.

Create a New Service Request

Describe the issue stating that SharePoint date fields using the TODAY() function are displaying the wrong date. Provide examples of the affected lists and mention that the problem persists across multiple users.

Provide Required Logs

If requested by the support team, generate and attach HAR (HTTP Archive) logs to help them investigate the network requests and backend desynchronization.

Submit a Support Ticket to Microsoft 365 Admin Center

Administrator Access Required: Only users with Microsoft 365 global or support administrator roles can open a service request. If you are an end-user, contact your IT department.

Free Microsoft Office alternative

Try WPS Office for Reliable Spreadsheet and Document Management

While waiting for cloud-based backend issues to be resolved, consider using WPS Office for your local and offline document needs. It offers a lightweight, highly compatible suite that perfectly supports Microsoft Word, Excel, and PowerPoint formats without relying on heavy server-side syncs for basic functions.

1. Download the Installer: Visit the official WPS Office website and download the appropriate version for your operating system.
2. Install the Software: Run the downloaded installation file and follow the on-screen prompts to complete the setup.
3. Open Your Documents: Launch WPS Spreadsheets or Writer and open your existing Microsoft Office files to continue working seamlessly.

Fully compatible with Microsoft Office formats including DOCX, XLSX, and PPTX.Reliable built-in spreadsheet date and time functions that run locally without server sync delays.Lightweight application that runs smoothly on Windows, Mac, and Linux.Free to use with a highly familiar and user-friendly interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why does clearing browser cookies only temporarily fix the SharePoint date issue?

Clearing cookies forces your browser to request a fresh page load rather than loading cached data. While this might temporarily display the correct date, the underlying server-side bug in SharePoint will eventually push the incorrect outdated date back to the frontend.

Can I use a different formula to fix the TODAY() function bug in SharePoint?

If the issue stems from a backend service bug affecting how SharePoint processes current date variables, alternative formulas that rely on today's date will likely yield the same incorrect results until Microsoft patches the server.

How do I capture HAR logs for Microsoft Support?

You can capture HAR logs by opening your browser's Developer Tools (usually by pressing F12), navigating to the 'Network' tab, ensuring 'Preserve log' is checked, reproducing the issue by loading the affected SharePoint page, and then right-clicking the network grid to select 'Save all as HAR with content'.

Office Quick Solutions