SharePoint Document Issues

Fix SharePoint Date Column Changing by One Day When Edited

Olivia MillerOlivia Miller Oct 19, 2026 870 views

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.

How to Fix SharePoint Date Column Changing by One Day When 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 you start

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.

Solution 1Recommended

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.

1
Open Site Settings

Navigate to your SharePoint site and click the Settings (gear) icon located in the top right corner of the page.

2
Access All Site Settings

Select 'Site information' from the panel, and then click on the 'View all site settings' link at the bottom.

3
Open Regional Settings

Under the 'Site Administration' section, find and click on 'Regional settings'.

4
Adjust the Time Zone

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.

Check Site Regional and Time Zone Settings
Note on User-Level Settings: Individual users may also have personal language and region settings in their Microsoft 365 profile that override site settings. Ensure these align as well.
Free Microsoft Office alternative

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. 1. Download the Installer: Visit the official WPS Office website and click the free download button.
  2. 2. Install and Launch: Run the installation package and follow the on-screen instructions to set up WPS Office.
  3. 3. Open Your Files: Launch WPS Office and open your existing spreadsheets and documents to experience seamless editing.
Fully compatible with Microsoft Office formats (DOCX, XLSX, PPTX, CSV).Reliable date and time formatting without unexpected time zone shifts.Free and lightweight, ensuring fast document loading and editing on any device.Familiar user interface that requires zero learning curve for Office users.
microsoft office alternative - wps office

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.