Forum Discussion
SharePoint List Date Format Not Matching Site Locale Setting
Hi everyone, I have just started experiencing an issue with a SharePoint List, where the date and time format doesn't match the column requirements. While our users can type out the date and time...
I am reasonably certain it did NOT used to be like that ... we changed so many things so many different times, I likely neglected to change it back to whatever it used to be (happy coincidence?).
Looking at those screenshots, I see that at one point I updated my MS Account profile to be United States, but changed the format to be yyyy-mm-dd instead of the detault US MM-DD-YYYY.
IDK - good luck though!
Looking at those screenshots, I see that at one point I updated my MS Account profile to be United States, but changed the format to be yyyy-mm-dd instead of the detault US MM-DD-YYYY.
IDK - good luck though!
Quick update; no combination of region settings has had any effect in solving this issue. Selecting time and date in a list column still defaults to USA date format regardless of region settings.
- Yeah, very irritating. Just started seeing this issue and we are also based in Canada. At first I thought it would be PC settings conflicting with SharePoint, but both are set to Canada. I also checked Edge's Language Settings and changed the "Share additional operating system region" to "Always (not recommended)", and that made no difference.
- We've also started to have this exact issue. Started with a couple of users, now seems to be impacting more. Haven't found a pattern yet.
- Sorry it didn't work for you. We have confirmed these settings work in our environment for more users than just me :). Our IT lead on the case had one and only one difference from my user and that was the date format in the MS account's regional settings. They had already switched it to English (United States), but their format was still mm/dd/yyyy. They updated the format to be yyyy-mm-dd, waited for an hour, and then they were able to enter dates in the lists without issue - bizarre.
