Forum Discussion
SharePoint List Date Format Not Matching Site Locale Setting
Long reply - lots of frustration with this issue here.
We also had this issue pop up out of nowhere about a month ago. We are located in Canada and require the yyyy-mm-dd format, but SP lists started defaulting mm/dd/yyyy. It impacts some users, but not all users. No regional, locale, date, language or format settings had been changed in SP, Windows, Individual Microsoft Account, or Individual Delve Settings in m365. Our SP regional settings are set to English (Canada), while our regional format in Windows, m365 and Microsoft accounts are defaulted with English (United States), this setup worked fine until recently.
We have had an escalated case open with an MS engineer since the issue started, and after multiple streaming sessions with various engineers, the issue remains outstanding and unresolved.
As part of the troubleshooting process, we changed every regional, language, date format setting possible in SP, Windows, Microsoft Account, and Delve Settings in m365 and tried various combinations in an effort to make this work. Having no impact whatsoever, I restored all my settings back to what they been originally (this was two days ago) and my lists still failed at that time.
Lo and behold, this morning my list settings are correct, though other users are still experiencing the same issue. For one of these users (who has been our IT lead with MS on this case), we have changed all of their settings to match what I currently have and will test it tomorrow to see if 24 hours is needed for all updates to process?
One last tidbit: my login can now enter dates in the lists correctly. If however, I log into SP with the admin login, the list problem occurs for them. So that rules out local windows settings and anything to do with sharepoint. the only difference between those two accounts is the m365 delve settings and the microsoft account settings, the admin login has the regional settings of English (Canada) in both...
We are not going to change any of the admin login's info as we will leave that as it has always been until this 'bug?' is fixed or until we confirm via testing with other users that the fix is in fact to remove any reference to English (canada) except in the SP regional settings.
Hi Jesse_Dan,
I appreciate you spending the time to share your findings! We are also located in Canada and require the YYYY-MM-DD format.
I think the difference between your account and the admin account relating with Delve and M365 account settings is promising. Are you able to share with me the settings for M365 and Delve which seemed to have resolve the issue?
Our M365 account settings region is set to English (Canada) with the YYYY-MM-DD format.
When looking at the Delve region settings (which forwards you to SP user profile settings), our region settings are following the site configuration.