SharePoint Document Issues

Fix SharePoint Today's Date Default Value Not Appearing in Forms

John WilsonJohn Wilson Oct 22, 2026 869 views

Question details

User needs the 'Today's Date' default value to correctly appear and reflect the current local date in SharePoint list forms.

Fix SharePoint Today's Date Default Value Not Appearing in 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.
Before you start

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.

Solution 1Recommended

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.

1
Access Site Settings

Navigate to your SharePoint site, click the Gear icon (Settings) in the top right corner, and select 'Site Information'.

2
View All Settings

Click on 'View all site settings' at the bottom of the Site Information panel.

3
Open Regional Settings

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

4
Update Time Zone

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.

5
Verify the Fix

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.

Adjust SharePoint Site Regional Settings
Existing Items Need Manual Updates: Changing the regional settings will apply to new list items automatically. Existing items with blank or incorrect dates will need to be manually updated.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website, click 'Download WPS Office Free', and follow the installation prompts.
  2. 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. 3. Open and Edit Seamlessly: Launch WPS Office, open your downloaded .docx, .xlsx, or .pptx file, and enjoy full formatting compatibility while editing.
Fully compatible with Microsoft Office formats (.docx, .xlsx, .pptx) exported from SharePoint.Lightweight design ensures fast loading times for viewing and editing local copies of team documents.All-in-one suite with a familiar interface, requiring zero learning curve to boost your workflow.Free access to essential office tools, saving subscription costs while maintaining full productivity.
QA img-9

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.