Fix SharePoint Today's Date Default Value Not Appearing in Forms
Question details
User needs the 'Today's Date' default value to correctly appear and reflect the current local date in SharePoint list forms.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- Creating a new item in a SharePoint list or form where a date column is configured to default to 'Today's Date'.
- Observed behavior
- The date field either displays an unexpected value or remains completely blank due to regional and time-zone setting mismatches.
Ensure you have Site Owner or Site Collection Administrator permissions, as standard users cannot modify the site-wide regional settings required to fix this issue.
Adjust SharePoint Site Regional Settings
Fix the default date issue by aligning the SharePoint site's time zone with your physical location.
SharePoint determines the 'Today's Date' value based on the site's regional settings rather than your local PC's clock. If the site time zone differs from your location, date calculations can shift across midnight, resulting in incorrect or blank defaults.
Navigate to your SharePoint site, click the Gear icon (Settings) in the top right corner, and select 'Site Information'.
Click on 'View all site settings' at the bottom of the Site Information panel.
Under the 'Site Administration' section, click on 'Regional settings'.
Locate the 'Time Zone' dropdown, select the correct time zone for your physical location (e.g., UTC+07:00 for Thailand), and click 'OK' to save.
Go back to your SharePoint list, click 'New' to create a new item, and confirm that the default date now accurately reflects today's date.

Seamlessly Handle Your Documents with WPS Office
While SharePoint manages your lists and online collaboration, you often need a reliable desktop suite to handle the actual files. WPS Office is a highly compatible, free, and lightweight alternative to Microsoft Office that flawlessly supports Word, Excel, and PowerPoint formats downloaded directly from SharePoint.
- 1. Download and Install WPS Office: Visit the official WPS website, click 'Download WPS Office Free', and follow the installation prompts.
- 2. Export your SharePoint Document: In your SharePoint document library, select the file you want to work on, click 'Download', and save it to your local drive.
- 3. Open and Edit Seamlessly: Launch WPS Office, open your downloaded .docx, .xlsx, or .pptx file, and enjoy full formatting compatibility while editing.

Frequently Asked Questions
Why does the SharePoint date show yesterday's or tomorrow's date?
This happens when the SharePoint site's server time zone differs drastically from your local time zone. If it is past midnight in your local time but not on the server, the 'Today's Date' formula will return the server's current date, which may be a day behind or ahead.
Can I change my personal time zone in SharePoint instead of the entire site?
Yes, users can adjust personal regional settings in their SharePoint profile. Click your profile picture, go to 'My Office profile', select 'Update profile', and change your 'Language and Region' settings to override the site default for your specific view.
Will fixing the time zone automatically update past entries that have incorrect dates?
No, updating the site's regional settings only impacts how 'Today's Date' is calculated for new items and future edits. You must manually correct the date on items created prior to the time zone change.




