User Profile
pillbox
Copper Contributor
Joined Dec 28, 2022
User Widgets
Recent Discussions
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, it is inconvenient especially considering this issue only recently started showing itself. When selecting a date and time in a list column, the format defaults to Month/Day/YYYY HH:MM AM/PM. This list, for the past few months, has always used YYYY-MM-DD HH:MM AM/PM for date format. The region setting at the site level is set to English (Canada), and our official national date format is YYYY-MM-DD. What do you think the problem could be? Why would this suddenly start happening despite the list being used for many months without issue? Column input: Column settings: Regional settings:Re: SharePoint List Date Format Not Matching Site Locale Setting
Thanks Jesse_Dan, I've updated my settings to yours exactly (other than timezone) and will monitor. It is interesting to me that your Delve region setting is set to United States as their date format is MM-DD-YYYY. If I don't see any changes by end of Monday I will try Canada and continue to monitor.Re: SharePoint List Date Format Not Matching Site Locale Setting
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.Re: SharePoint List Date Format Not Matching Site Locale Setting
Hi Ganesh, We have not changed any language or region settings at the user-level. The site, list, user, endpoint, and browser have not seen any changes prior to and during the discovery of this issue. I've confirmed the regional format settings under the affected Microsoft accounts are also set to YYYY-MM-DD.
