Forum Discussion
Date format microsoft teams
Hello ChrisHoardMVP
Thank you for your answer.
I tried myself to do the issue on team, here is the point:
- All my account settings are in French.
- I want the format date to be in French, so this format: DD-MM-YYYY
- When I write the date in the french format in teams, the soft keep change it in english format : MM-DD-YYYY
- The format date in the soft settings is in full english.
In this screenshots, I wrote the date in french format, in the cell it appears in english format. In the row "Ajout" I add 15 days at the first date, and still add it in the bad format.
I wanted to write "06/02/2020" as 6th February 2020.
Thank you in advance.
Christopher & Thomas,
Please note that MM/DD/YYYY is an AMERICAN date format ONLY, absolutely not UK English (and this is what it has always been referred to in the computer community since I started encountering this problem back in 1983).
In the UK (That's England, Scotland and Northern Ireland) we use MM/DD/YYYY as you do in France. We also have our own character set and keyboard layout (437 / UK English spring to mind) which is definitely not a US keyboard layout or character set or a French AZERTY keyboard layout (which befuddles everybody outside France and the 'Doms').
Back in the early days of windows programming all 'Locale' (i.e. what currency symbol/date format/language etc.) information was to be obtained ONLY from the machine on which you are running the programme (i.e. NEVER the server). I'm not aware this ever changed as it makes considerable sense, but I'm not a programmer any more so can't be sure.
If this is the case though it doesn't seem to be working with Microsoft Teams. I'm getting US short date format (MM/DD) when my machine is set to UK Locale with UK date formats which are the same as yours in France.
Advice on the forums is, as usual, patchy with some contributors seeming not to understand that there is a difference between US & UK/European date formats and counselling that changing local settings will put it right (which it should but doesn't).
Ho Hum - best of luck
Seems you have wiped Wales off the UK map? Just thought I'd fly the flag for us in Wales even if it is a post from 2 years ago.
