Fix SharePoint Date and Time Fields Not Showing Today's Date
Question details
The user needs a SharePoint date and time field to default to today's date.

- Product
- Microsoft SharePoint
- Device & OS
- not provided
- Scenario
- A modern SharePoint list has a date and time column configured with the Today's Date default.
- Observed behavior
- The field may not display today's date even though the Today's Date setting is enabled.
Open the affected list and check the date column's settings to confirm that Today's Date is selected as the default. Test the default on a new item, since changing a column's default does not update existing items.
Test the Date Column in Other SharePoint Lists
Use a new item and other lists or sites to determine how widely the issue occurs.
In the affected list, open the date column's menu, select Column settings, and choose Edit. Under Default value, confirm that Today's Date is selected and save the setting.
Select New in the list and check whether the date field displays today's date. Save the item and check the displayed value again.
Open another list or create a test list with a date and time column set to Today's Date. Select New and compare its behavior with the affected list.
If you have permission, repeat the test in a new SharePoint site. Record which lists and sites are affected before contacting your SharePoint administrator.

Try a Calculated Column as a Date Workaround
Use a calculated date value as a workaround if your SharePoint environment accepts the NOW() formula.
Work With Office Files Alongside SharePoint Using WPS Office
WPS Office is a free, lightweight alternative for working with documents and spreadsheets in a familiar interface. Its Office format support makes it easy to move files between WPS and Microsoft Office, though it does not fix SharePoint list settings.

Frequently Asked Questions
Does the Today's Date default update existing SharePoint items?
No. The default applies when a new item is created; changing the column setting does not automatically replace dates in existing items.
How can I tell whether the problem affects more than one list?
Create or open another list, add a date and time column with Today's Date as its default, and select New to test it. If possible, repeat the test on another SharePoint site.
Will creating a new date and time column fix the issue?
Not necessarily. A new column in the same list may behave the same way. Test another list or site to help identify the scope.
Does a calculated column using NOW() update automatically every day?
Do not rely on it to update continuously. Calculated values may be recalculated only when an item is created or edited, and the formula must be accepted by your SharePoint environment.




