Fix SharePoint Date Column Changing by One Day When Edited
Question details
The user needs to prevent a Date column in a SharePoint list from automatically shifting back by one day when a record is clicked or edited.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Editing existing list items containing a Date and Time column in a SharePoint list.
- Observed behavior
- The date value automatically reduces by one day (e.g., from 10/14/1972 to 10/13/1972) upon entering edit mode, affecting existing records across the list but not newly created ones.
Before modifying site configurations, ensure you have Site Owner or Administrator permissions to adjust regional settings and verify whether the issue persists across different web browsers.
Check Site Regional and Time Zone Settings
Ensure that the SharePoint site's time zone matches your local time zone, as mismatches often cause date shifts during editing.
SharePoint handles dates internally using UTC. If there is a discrepancy between the site's regional time zone settings and your local system time, dates may visually shift by a day when converting between display mode and edit mode.
Navigate to your SharePoint site and click the Settings (gear) icon located in the top right corner of the page.
Select 'Site information' from the panel, and then click on the 'View all site settings' link at the bottom.
Under the 'Site Administration' section, find and click on 'Regional settings'.
Check the 'Time Zone' dropdown menu. Ensure it correctly matches your local time zone or the intended time zone for the team, then click 'OK' to save.

Isolate the Issue with a New Column
Create a fresh Date and Time column to determine if the issue is isolated to the existing column's configuration or affects the entire list architecture.
Open a Microsoft 365 Support Ticket
If the issue only affects existing records and persists after verifying regional settings, it is likely a backend synchronization anomaly requiring Microsoft's intervention.
Try WPS Office for Your Document Management Needs
While SharePoint backend issues might disrupt your list workflows, dealing with documents shouldn't be a hassle. WPS Office offers a lightweight, highly compatible alternative for managing spreadsheets, documents, and presentations without unexpected formatting or date shifts.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install and Launch: Run the installation package and follow the on-screen instructions to set up WPS Office.
- 3. Open Your Files: Launch WPS Office and open your existing spreadsheets and documents to experience seamless editing.

Frequently Asked Questions
Why does my SharePoint date column change to the previous day?
This typically happens due to a time zone mismatch between the SharePoint site's Regional Settings and your local computer's time zone. When clicking the field, the system attempts to convert the UTC stored date to your local time, causing it to shift backward.
How can I change the time zone on my SharePoint site?
As a Site Owner, click the Settings (gear) icon in the top right corner, go to 'Site information', and click 'View all site settings'. Under the 'Site Administration' heading, click 'Regional settings' and adjust the Time Zone dropdown.
Are newly created records affected by this SharePoint date bug?
In many cases involving backend synchronization issues, newly created records remain unaffected. The date shifting bug usually impacts only pre-existing records when they enter edit mode.
Can I fix the backend SharePoint list date error myself?
If adjusting the site and personal regional settings does not resolve the issue for existing records, it is likely a backend database anomaly. You will need a global admin to contact Microsoft 365 Support for remote log collection and a backend repair.




