Fix SharePoint Date Column Showing Yesterday Instead of Today
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'.

- 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.
Ensure you have site owner or administrator permissions to modify regional settings in SharePoint, and verify your actual local time zone for comparison.
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.
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'.
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.
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.
Configure Column Settings to Date Only
Changing the column format from Date and Time to Date Only can resolve minor time conversion glitches if time tracking is not strictly required.
Adjust Date Formulas in Power Apps
If the list is connected to Power Apps, the application might be incorrectly double-converting the local time to UTC.
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. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded installer and follow the quick, on-screen instructions to set up the suite.
- 3. Open Your Office Files: Launch WPS Office and immediately open your existing Microsoft Office files with all formatting fully preserved.

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.




