Teams Lists Date/Time Format doesn't follow OS Settings, always US

Question

We wonder how Teams lists date/time format columns can be set up in such a way to use German format, like dd/mm/yyyy. For now in our Teams lists, date/time format is US like mm/dd/yyyy. My OS is English US, but my regional settings are set to German. I have also set my Teams to German language, without success. I tried different approaches, none with a positive result.

https://answers.microsoft.com/en-us/msteams/forum/all/ms-teams-is-there-a-way-to-change-datetime-format/34619efb-8535-43a7-b269-f84e35e5eb4e --> Teams is set to German, respectively I switched now to German, no success, Date/Time is still MM/DD/YYYY

https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-change-the-date-format-for-the-new/03206b6c-9ec0-4460-b38a-ccd3fdee30e7 --> this seems to point to SharePoint, eventually also OneDrive, settings, does not apply for Teams from what I can tell.

https://support.microsoft.com/en-us/office/change-settings-in-teams-b506e8f1-1a96-4cf1-8c6b-b6ed4f424bc7 --> Settings --> Time & Language does not exist for me.

Any suggestions would be highly appreciated,

thanks
Dieter

Answer 1

From what I can tell the main setting is within the SharePoint Site --> Regional Settings --> Locale

The Problem here is that from my research results this cannot be changed by default to something else but US. Afterwards it can be changed, but this is a bit of an issue. Because an user sets up a Team channel, and if he does not think about this setting, it will be US for a start. Later on he might figure it's something wrong, but that's to late for already created Date/Time fields.....

This post covers it very well: https://itsallinthecode.com/sharepoint-automatically-set-regional-settings-on-all-new-sites/

It also describes the problem:

The good news is now you can set the default time zone for all new sites via the SharePoint admin center. This works well if your users are not spread across the globe. If they are, then you can either set the timezone on a site by site basis or use a script to provision sites and perhaps set the time zone based on the information provided by the requester.

However, there is still no option to set the locale and region tenant-wide, so that still needs to be done via a script (or manually). There is an open user voice here that you can vote on to request this missing feature.