Fix SharePoint Document Set Date Inheritance Showing Previous Day
Question details
The user needs to resolve an issue where files inside a SharePoint Document Set inherit a date that is one day earlier than the original Document Set date.
- Product
- SharePoint
- Device & OS
- not provided
- Scenario
- Inheriting Date and Time metadata from a Document Set to its child files.
- Observed behavior
- The inherited date displays as the previous day when the SharePoint site's time zone differs from the user's local time zone.
Ensure you have site owner or administrator permissions to view and modify the SharePoint site's regional time zone settings.
Align Site and User Time Zone Settings
Synchronizing the site's regional time zone with the user's local time zone prevents SharePoint from incorrectly shifting the date backward during time zone conversion.
SharePoint stores Date and Time column values in Coordinated Universal Time (UTC). When a user views the date, SharePoint converts the UTC time to the time zone configured in the site's regional settings. If the site's time zone is behind the user's time zone, a date saved at midnight will be shifted to the late evening of the previous day.
Go to your SharePoint Site and click the 'Settings' (gear) icon in the top right corner.
Select 'Site information' from the panel, and then click on 'View all site settings' at the bottom.
Under the 'Site Administration' section, click on 'Regional settings'.
Locate the 'Time Zone' dropdown menu and change it to match the local time zone of the users interacting with the Document Set.
Click 'OK' to save the changes, then upload a new document to the Document Set to verify if the date inheritance now displays correctly.
Escalate to Microsoft Support
If adjusting the regional settings does not resolve the inheritance bug, escalate the issue through the Microsoft 365 admin center for further backend investigation.
Try WPS Office for Seamless Document Management
While dealing with complex SharePoint and Microsoft 365 metadata syncing issues, you might want a reliable, lightweight alternative for your daily document creation and editing. WPS Office offers a complete suite that is highly compatible with Microsoft formats without the server-side glitches.
Frequently Asked Questions
Why does SharePoint change the dates on my uploaded files?
SharePoint stores Date and Time column values in Coordinated Universal Time (UTC). When displaying the date, it converts the UTC time to the time zone configured in the site's regional settings. If the time zones differ, the visual output can shift to the previous day.
Can I set the time zone on a per-user basis in SharePoint?
Yes, users can configure their personal regional settings in their SharePoint user profile. However, if the site defaults strongly conflict or if Document Set inheritance forces a site-level conversion, mismatches may still occur.
Does this date shift affect 'Date Only' columns?
Yes. Even if a column is set to 'Date Only', SharePoint still internally processes it with a default time (usually midnight). A time zone shift backward will change midnight of one day to the late evening of the previous day.
What is a SharePoint Document Set?
A Document Set is a specific type of folder in SharePoint that allows you to manage multiple documents as a single work product. Documents inside the set can automatically inherit metadata, such as dates or statuses, from the parent Document Set.
