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.
pillbox here you go. Also - when I changed my settings back to below for my user the issue did not resolve that day, it wasn't until a couple days later ... who knows if that had any bearing at all.
Here are the settings for my user in my MS account:
Delve settings, note I have changed the Region Settings to tbe 'Always use my personal settings'
Settings for the admin user that does not work:
- Thanks for your screenshots Jesse_Dan.
When you set your MS account and Delve settings as per your screenshots, did the dates on lists display as YYYY-MM-DD or did they change to MM/DD/YYYY? I have an account which recently started experiencing this issue on a SharePoint site set to use English (Canada) and when I made my settings match yours, I was once again able to enter dates using the date picker without error. However, they all displayed in the list as MM/DD/YYYY.
