SOLVED

Date Format MS Teams Planner

%3CLINGO-SUB%20id%3D%22lingo-sub-377135%22%20slang%3D%22en-US%22%3EDate%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Tahoma%22%20size%3D%222%22%3EThe%20date%20format%20in%20MS%20Teams%20Planner%20tab%20showing%20by%20default%20as%20mm%2Fdd%2Fyyyy%2C%20however%2C%20I%20need%20in%20the%20dd%2Fmm%2Fyyyy%20and%20managed%20to%20fix%20it%20at%20user%20level%20by%20changing%20the%20default%20language%20to%20English%20(Australia)%20as%20per%20below%20steps%3A%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Tahoma%22%20size%3D%222%22%3EHow%20I%20can%20change%20the%20language%20to%20English%20(Australia)%20for%20all%20users.%20Our%20office%20365%20hybrid%20environment.%20%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%3CFONT%20color%3D%22%23000000%22%20face%3D%22Tahoma%22%20size%3D%222%22%3EThanks%20for%20your%20help.%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Teams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-451727%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-451727%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3EI%20am%20interested%20in%20it%20too%2C%20both%20Planner%20and%20Files%20show%20MM%2FDD%2FYYYY%20format%20via%20Teams%20client%20(%3CSPAN%3ETeams%20Version%201.2.00.7161%20(64-bit).%20It%20was%20last%20updated%20on%204%2F6%2F19.%3C%2FSPAN%3E)%2C%20but%20my%20Country%20and%20Region%20in%20settings%20are%20set%20correctly.%20SharePoint%20Team%20site%20also%20has%20correct%20regional%20settings.%20Anything%20else%20we%20would%20be%20missing%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377448%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377448%22%20slang%3D%22en-US%22%3E%3CP%3ETeams%20client%20follows%20Windows%20settings%20in%26nbsp%3B%3CSTRONG%3ERegion%20%26amp%3B%20language%3C%2FSTRONG%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20Windows%2010%3A%3C%2FSPAN%3E%3C%2FP%3E%3COL%3E%3CLI%3EOpen%20%3CSTRONG%3ESettings%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EClick%20on%20%3CSTRONG%3ETime%20%26amp%3B%20Language%3C%2FSTRONG%3E.%3C%2FLI%3E%3CLI%3EClick%20on%20%3CSTRONG%3ERegion%20%26amp%3B%20language%3C%2FSTRONG%3E.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20762px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F93922i5D12101986565A93%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-686385%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-686385%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F190064%22%20target%3D%22_blank%22%3E%40Badal%20Ratra%3C%2FA%3E%26nbsp%3BI%20also%20have%20this%20problem%20using%20planner%20in%20a%20teams%20tab%20SP%20site%20and%20everything%20else%20all%20set%20to%20UK%20in%20regional%20settings%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-737768%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-737768%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20incorrect.%20Planner%20does%20not%20take%20the%20region%20settings%20from%20the%20user's%20local%20PC.%20Teams%20may%20do%20this%2C%20but%20Planner%20does%20not.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-738149%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-738149%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F371001%22%20target%3D%22_blank%22%3E%40locaris%3C%2FA%3E%26nbsp%3BPlease%20go%20to%20the%20question%20for%20this%20thread%2C%20it%20was%20in%20about%20changing%20the%20date%20in%20Teams%20client%20for%20the%20planner%20tab%20in%20Teams.%20Not%20changing%20date%20format%20in%20Planner%20web%20app.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20change%20the%20app%20language%20in%20Teams%2C%20the%20date%20format%20for%20the%20Planner%20tab%20in%20Teams%20will%20change.%20When%20you%20start%20Teams%20for%20the%20first%20time%20it%20will%20follow%20the%20region%20settings%20in%20Windows.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20want%20to%20you%20can%20test%20by%20changing%20app%20language%20in%20Teams%20yourself%20and%20you%20will%20see%20that%20the%20date%20format%20will%20change%20if%20you%20have%20a%20planner%20tab%20in%20Teams.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-782619%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-782619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F190064%22%20target%3D%22_blank%22%3E%40Badal%20Ratra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20went%20to%20the%20...%20beside%20the%20Planner%20name%20-%26gt%3B%20Sites%20-%26gt%3B%20Site%20Settings%20-%26gt%3B%20Regional%20settings%20-%26gt%3B%20change%20Locale%20to%20English%20(Australia).%3C%2FP%3E%3CP%3EMel%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1098015%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1098015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F190064%22%20target%3D%22_blank%22%3E%40Badal%20Ratra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20teams%20client%2C%20click%20on%20your%20profile%20picture%20at%20top%20right%20-%26gt%3B%20Settings%20-%26gt%3BGeneral%20-%26gt%3B%20Language-%26gt%3B%3C%2FP%3E%3CP%3E%22App%20language%20determines%20the%20date%20and%20time%20format%22.%3C%2FP%3E%3CP%3ESelect%20an%20English%20language%20other%20than%20%22English%20(United%20States)%22%20such%20as%20%22English%20(Australia)%22%3CBR%20%2F%3EClick%20%22Save%20and%20Restart%22%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1157704%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1157704%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3EHi%2C%20that%20is%20totally%20weird%2C%20because%20in%20Windows%20there%20is%20also%20%3CSTRONG%3ERegional%20format%3C%2FSTRONG%3E%20setting.%20I%20want%20my%20user%20interface%20in%20English%20(US)%20but%20dates%20displayed%20in%20my%20regional%20format.%20I%20thnik%20Teams%20should%20follow%20this%20setting%20for%20dates%20and%20not%20assume%20it%20from%20the%20user%20interface%20language.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MartinPetvalsky_0-1581060073226.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F169579i53FEA7E261D82701%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22MartinPetvalsky_0-1581060073226.png%22%20alt%3D%22MartinPetvalsky_0-1581060073226.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBR%20Martin%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1157805%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1157805%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F548428%22%20target%3D%22_blank%22%3E%40MartinPetvalsky%3C%2FA%3E%26nbsp%3BThere%20is%20a%20uservoice%20that%20suggests%20that%20Teams%20should%20follow%20the%20regional%20settings%20in%20Windows.%20Vote%20for%20it%2C%20it%20is%20currently%20status%20%22On%20the%20backlog%22%20so%20Microsoft%20is%20not%20working%20with%20it%20right%20now%20but%20probably%20will%20in%20the%20future.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16935160-use-same-date-and-time-format-as-in-my-computer-s%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmicrosoftteams.uservoice.com%2Fforums%2F555103-public%2Fsuggestions%2F16935160-use-same-date-and-time-format-as-in-my-computer-s%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1163507%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1163507%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9476%22%20target%3D%22_blank%22%3E%40Linus%20Cansby%3C%2FA%3E%26nbsp%3Bthanks%20for%20the%20link!%20voted.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1482455%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20Format%20MS%20Teams%20Planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1482455%22%20slang%3D%22en-US%22%3E%3CP%3Ewhy%20is%20this%20still%20a%20thing%20years%20later%3F%20It's%20such%20a%20simple%20thing.%20Date%20formats%20aren't%20all%20the%20illogical%20US%20system%20in%20most%20parts%20of%20the%20world.%20Why%20aren't%20the%20regional%20settings%20pulled%20from%20the%20Desktop%20system%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Frequent Contributor

The date format in MS Teams Planner tab showing by default as mm/dd/yyyy, however, I need in the dd/mm/yyyy and managed to fix it at user level by changing the default language to English (Australia) as per below steps:

 

How I can change the language to English (Australia) for all users. Our office 365 hybrid environment.

Thanks for your help.

20 Replies
best response confirmed by Badal Ratra (Frequent Contributor)
Solution

Teams client follows Windows settings in Region & language.

In Windows 10:

  1. Open Settings.
  2. Click on Time & Language.
  3. Click on Region & language.

image.png

 

@Linus CansbyI am interested in it too, both Planner and Files show MM/DD/YYYY format via Teams client (Teams Version 1.2.00.7161 (64-bit). It was last updated on 4/6/19.), but my Country and Region in settings are set correctly. SharePoint Team site also has correct regional settings. Anything else we would be missing?

@Badal Ratra I also have this problem using planner in a teams tab SP site and everything else all set to UK in regional settings

@Linus Cansby 

This is incorrect. Planner does not take the region settings from the user's local PC. Teams may do this, but Planner does not.

@locaris Please go to the question for this thread, it was in about changing the date in Teams client for the planner tab in Teams. Not changing date format in Planner web app. 

 

If you change the app language in Teams, the date format for the Planner tab in Teams will change. When you start Teams for the first time it will follow the region settings in Windows.

 

If you want to you can test by changing app language in Teams yourself and you will see that the date format will change if you have a planner tab in Teams.

@Badal Ratra 

I went to the ... beside the Planner name -> Sites -> Site Settings -> Regional settings -> change Locale to English (Australia).

Mel

 

@Badal Ratra 

In the teams client, click on your profile picture at top right -> Settings ->General -> Language->

"App language determines the date and time format".

Select an English language other than "English (United States)" such as "English (Australia)"
Click "Save and Restart"

@Linus CansbyHi, that is totally weird, because in Windows there is also Regional format setting. I want my user interface in English (US) but dates displayed in my regional format. I thnik Teams should follow this setting for dates and not assume it from the user interface language.

 

MartinPetvalsky_0-1581060073226.png

 

BR Martin

 

@TeamGroupware There is a uservoice that suggests that Teams should follow the regional settings in Windows. Vote for it, it is currently status "On the backlog" so Microsoft is not working with it right now but probably will in the future.

 

https://microsoftteams.uservoice.com/forums/555103-public/suggestions/16935160-use-same-date-and-tim...

@Linus Cansby thanks for the link! voted.

why is this still a thing years later? It's such a simple thing. Date formats aren't all the illogical US system in most parts of the world. Why aren't the regional settings pulled from the Desktop system?

@djwhu thx for the simple clarification. this works and guides us to the right spot. 

"App language determines the date and time format" doesn't come up in Teams. It just says: "App language". What happens when I use English language (UK or Australia doesn't make a difference) the date and time format are shown as 1AM and 1/22 - which are NOT my Windows settings.

It worked well before my Windows update on 22nd January from 1909 to 2004.

 

Now it is scrap

@Linus Cansby did that and restarted and nothing's changed, still in US format

pjcons_0-1611904449439.png

 

@pjcons Looks like the status is still "Working on it", so no update there.

Use same date and time format as in my computer's settings – Microsoft Teams UserVoice

@Badal Ratra Nearly two years later and this isn't fixed.

jamesatdps_0-1614037999680.png

How do I get it to display in my local format? All my settings are set to Australia - in Teams, Planner, and Windows. What else can I do?

 

@jamesatdps Same for me. Driving me nuts. Did you get any traction on resolving this? I am using MS Planner within 365 Online.

 

Look at this--meant to be 09/12/2021

 

PretzelPete_0-1617233195457.png

 

Drives me totaly nuts too. This is really confusing for non-US citizens and can lead to incorrect planning expectations for the team. For example 

04/08 is 4th August in Europe but 08th April in US. That's quite some differences in available time to complete a task! 

@Badal Ratra For the Australian's amongst us, I found that changing the language format to English (Australia) changed the date to our normal dd/mm format which is shown in the attached image (Date 1) when List view is showing, however, when the actual task is opened, the date reverts back to US style, mm/dd (see other attachment - Date 2)