SharePoint Document Issues

Fix SharePoint Date Column Showing Yesterday Instead of Today

John WilsonJohn Wilson Nov 3, 2026 869 views

Question details

The user needs to correct a SharePoint Date and Time column that incorrectly displays the previous day when configured to default to 'Today'.

How to Fix SharePoint Date Column Showing Yesterday
Product
Microsoft SharePoint
Device & OS
not provided
Scenario
Viewing or entering data into a SharePoint list or a connected Power Apps form where the default date is expected to be the current day.
Observed behavior
The column displays yesterday's date instead of today's date, typically due to mismatched UTC and local time zone calculations across the site, user profile, or app settings.
Before you start

Ensure you have site owner or administrator permissions to modify regional settings in SharePoint, and verify your actual local time zone for comparison.

Solution 1Recommended

Align SharePoint and Microsoft 365 Regional Settings

Ensuring both the SharePoint site and the user's Microsoft 365 profile share the exact same time zone prevents UTC offset issues that shift dates backwards.

SharePoint stores all date and time values in Coordinated Universal Time (UTC) internally. When a mismatch exists between the site's regional settings and the viewer's profile, the conversion back to local time can push the displayed date to the previous day.

1
Open Site Settings

Navigate to your SharePoint site, click the gear icon in the top right corner to open Settings, select 'Site information', and then click 'View all site settings'.

2
Adjust Regional Settings

Under the 'Site Administration' section, click on 'Regional settings'. Check the 'Time zone' dropdown and ensure it matches your correct local time zone, then click OK.

3
Check Microsoft 365 Profile

Go to your personal Microsoft 365 account settings by clicking your profile picture. Navigate to 'Settings & Privacy' > 'Language and region' and confirm that your personal time zone matches the site's configuration.

Synchronization Delay: It may take a few minutes for changes in Microsoft 365 profile settings to fully sync and reflect across all SharePoint lists.
Free Microsoft Office alternative

Experience Seamless Document Management with WPS Office

While dealing with complex SharePoint regional settings and Microsoft 365 synchronization can be frustrating, managing your actual documents shouldn't be. If you are looking for a robust, hassle-free environment to handle spreadsheets, documents, and presentations without complex cloud dependencies, WPS Office is a perfect, lightweight alternative.

  1. 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
  2. 2. Install the Software: Run the downloaded installer and follow the quick, on-screen instructions to set up the suite.
  3. 3. Open Your Office Files: Launch WPS Office and immediately open your existing Microsoft Office files with all formatting fully preserved.
Fully compatible with Microsoft Excel, Word, and PowerPoint file formats.Lightweight installation that runs smoothly on Windows, Mac, and Linux without complex regional setting dependencies.Completely free to use with a familiar, user-friendly tabbed interface for maximum productivity.Built-in PDF toolkit to edit, merge, and convert files effortlessly.
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint shift my date by one day?

SharePoint stores all date and time values in a backend database as Coordinated Universal Time (UTC). When viewing a list, SharePoint attempts to convert that UTC time to your local time zone. If the site's time zone setting differs from your user profile or browser's time zone, the conversion can result in the date shifting backwards to the previous day.

Can I stop SharePoint from converting dates to UTC entirely?

No, SharePoint inherently handles backend storage in UTC to support global teams. However, you can mitigate display issues by strictly formatting columns as 'Date Only' or ensuring all regional time zone settings are perfectly synchronized across your organization's Microsoft 365 environment.

Does my browser's time zone affect SharePoint dates?

Yes. If your Microsoft 365 profile is configured to automatically detect your time zone or relies on local device settings, a discrepancy between your computer's system time (or browser time) and the SharePoint server's time zone can cause the date to display as yesterday.