'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Microsoft Lists Displaying Different Dates in List and Form
Question details
Users report that dates entered correctly into a Microsoft Lists item form are displaying as a different date when viewing the overall list.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Adding or viewing items containing date and time values across different regional environments.
- Observed behavior
- The date appears correct inside the individual item form, but shifts to a different date (often off by one day) in the main list view.
Ensure you have administrator or site owner permissions, as you may need to adjust the SharePoint site's regional settings to resolve this issue.
Verify and Align Regional Settings
Date discrepancies typically occur when the underlying SharePoint site region does not match the user's local device, browser, or Microsoft 365 account settings.
Microsoft Lists rely on the regional settings of the SharePoint site hosting the list. If a user is located in Australia but the site is set to US time, the time zone conversion can cause the list view to shift dates by a day, even though the form retains the input data.
Click the gear icon in the top right corner of your Microsoft List, select 'Site settings', and click on 'Regional settings'. Ensure the Time Zone matches the primary user base.
Click your profile picture in Microsoft 365, select 'View account', go to 'Settings & Privacy', and confirm your personal Language and Region preferences.
Ensure that your Windows or Mac system clock and time zone settings are correct and correspond exactly to the region selected in your Microsoft account.
Modify Date and Time Column Configuration
Disabling friendly formatting or altering the column's time display can bypass certain service-side rendering glitches.
Contact Microsoft 365 Support with HAR Logs
If standard troubleshooting fails and the issue impacts multiple users across various browsers, escalate the issue as a service-side bug.
Manage Your Data Seamlessly with WPS Office
Tired of dealing with cloud sync errors and unexpected regional date formatting issues? WPS Office offers a completely free, highly compatible alternative for organizing your complex datasets. Work seamlessly offline and maintain precise control over your date and time formatting without server-side conflicts.
- 1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite for your device.
- 2. Export Your List: Export your problematic Microsoft List to a CSV or Excel file to secure your data.
- 3. Manage Offline: Open the exported file in WPS Spreadsheet to confidently manage your dates, records, and data without cloud rendering issues.
Frequently Asked Questions
Why does my Microsoft List show yesterday's date instead of today?
This usually happens due to a time zone mismatch. If the underlying SharePoint site is configured in a time zone that is hours behind your local time, dates entered in the form may be converted backward during server rendering, pushing them into the previous day in the list view.
Does clearing the browser cache fix list date display issues?
While clearing the cache or using an InPrivate window is a recommended initial troubleshooting step, consistent date display discrepancies in Microsoft Lists are typically tied to account or site regional settings rather than cached data.
What are HAR logs and why does Microsoft Support need them?
HAR (HTTP Archive) logs record the interaction between your web browser and the website. Microsoft Support uses them to analyze network requests and identify exactly where the service-side date conversion or rendering is failing.
