SharePoint Document Issues

Fix SharePoint Date and Time Fields Not Showing Today's Date

Huda QurayshiHuda Qurayshi Nov 14, 2026 868 views

Question details

The user needs a SharePoint date and time field to default to today's date.

Fix SharePoint Date and Time Fields Not Showing 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.
Before you start

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.

Solution 1Recommended

Test the Date Column in Other SharePoint Lists

Use a new item and other lists or sites to determine how widely the issue occurs.

1
Check the default setting

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.

2
Test a new item

Select New in the list and check whether the date field displays today's date. Save the item and check the displayed value again.

3
Compare another list

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.

4
Test another site

If you have permission, repeat the test in a new SharePoint site. Record which lists and sites are affected before contacting your SharePoint administrator.

Test the Date Column in Other SharePoint Lists
Creating another column may not help: A new date and time column in the same list may show the same behavior. Testing another list or site helps determine whether the issue is more widespread.
Free Microsoft Office alternative

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.

Open and edit Microsoft Word DOCX and Excel XLSX files.Use familiar document and spreadsheet tools with an easy-to-use interface.Work with dates in spreadsheets when organizing information outside a SharePoint list.Move existing Office files into a lightweight, free office suite.
microsoft office alternative - wps office

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.