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:Teams chat date format still wrong, not following OS.
The Teams desktop client (using it on Mac) is now supposed to follow OS regional settings for date/time formats, but it doesn't. In Finland, our shortest time format is "H.MM" and shortest date format is "d.m.yyyy" or, when the year is not required/applicable, "d.m.". Neither whitespace nor leading zeros are to be used anywhere in short date formats, leading zeros are used in minutes. When Teams formats dates for the chat list and drops the year, it assumes it's OK to leave out the trailing dot and, adding injury to insult, prepends leading zeros to single digit months. See where all this goes? Person One 10.10 Someone Else 11.11 Dude Three 12.12 F. Madman 15.06 Did I receive the latest message from each person in October, November, December and June or earlier today? Not kidding here; Please enjoy an actual screen snip.Date Formatting
I wonder if anyone could help me please? Its probably really simple but I can't for the life of me get Excel to do as I would like. On all our company graphs/pivots etc, date is displayed as 18/06 (yy/mm) I have tried using a custom format but it always defaults to a full date 01/06/2018 in the display bar even though displaying correctly in the data It causes havoc for my pivots. How can I have the column format my dates as YY/MM to display in the data and in the display bar? Please? Thank you Clair
