User Profile
pillbox
Copper Contributor
Joined 2 years ago
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:
