The date format is fixed to mm/dd/yyyy, could this please be selectable based on your region - for example we use dd/mm/yyyy
As an update, since we’ve still been seeing issues around date formatting, so we’re pursuing another fix that should help: If you’re using Planner within Teams, we will default to using the same language/local as Teams.
If you’re seeing this issue persist outside of Teams and your language/locale is set properly for your Office account, please let us know in the comments below!
The Planner Team
Jesty Karl Salvatierra commented
workaround is change the bit of "en-US" to "en-AU" or "en-GB" or whatever time format, but then again, keen to get a permanent fix for this please product team.
Peter Sv commented
From what I can see, this i still not fixed and there's no way to work around it. At least I can now stop searching for what I thought I'd overlooked. This is such a silly problem to have. Crazy and annoying
David Cooper commented
I couldn't wait any longer and we have moved to another product. Its really disappointing that no one is looking after the ecosystem of office365 rather the product teams seem to just develop by themselves and the app launcher has no consistency between products. Project online was just rolled out and it does exactly the same thing. It doesn't even have the AU locale correct.
We will not be adopting Planner in my (Australian) organsiation on the basis of this issue alone.
This may seem a small issue to Microsoft HQ is the US but it's enough to put a lot of UK users off of using Oklanner. Which is a shame, as it is otherwise a good product
Date format also incorrect when using the planner webpart in sharepoint online. The sharepoint site, and o365 user have the correct regional settings however the plan in the webpart is stuck using US date format. Can't even use the URL trick to change from en-us to en-au as this is not accessible when adding a web part in. Maybe the default format for all products should be DMY, would keep most of the planet happy: https://en.wikipedia.org/wiki/Date_format_by_country
Nick Van Maele commented
Still an issue in Belgium on 6 November 2019 (latest version of Teams installed, using Office 365 E3)
Nov '19 - this is still an issue in UK - just starting looking to use this in our office and amazed that some very basic functionality is missing here.
Thomas Hnz Reyes commented
When can we expect an actual fix for this? Its getting ridiculous how long this uservoice has been up and nothing has been done.
''If you’re seeing this issue persist outside of Teams and your language/locale is set properly for your Office account" - still an issue!
This is still an issue for us. We have users using Welsh language and planner will change to mm/dd when that is set. Changing to English UK fixes the date problem but then the language is obviously wrong!
Please make cy-gb (and en-au) follow en-gb date settings
Agree with other comment. Setting the language to English-Australian in Teams fixes Planner within a Teams tab, but when you launch out to a browser it defaults to en-US and the date format is therefore back to US.
We dont use Teams - we just use planner the web app.
I cannot change the date format from US to UK.
This is very annoying.
Yes, still an issue. I am using Planmaker as a stand alone outside of teams.
Yes still an issue!
Gilles Couzin commented
There is a discrepancy in the date format between looking at a plan from the Planner app itself or from the Planner web part embedded on a SharePoint site page.
The former shows the correct UK date format (i.e. dd/mm/yyyy) while the latter shows the same dates in the US format (i.e. mm/dd/yyyy). For example, a Start / Due date of 1st September 2019 shows as '01/09/2019' in the Planner app and as '09/01/2019' in the SharePoint Planner web part.
Regional settings are set correctly to UK, both in Office Profile and SharePoint, so this is a bug in the Planner web part, which makes it unusable outside the US.
Richard Griffin commented
Latest update from Microsoft - cut and paste so please don't blame me for the appalling spelling and grammar.
This is Sagar from the Office 365 Support.
Issue: Teams date format wrong
We have checked that this particular feature in Teams desktop client has not yet rolled out:
You can follow the link shown below:
In traditional American usage, dates are written in the month–day–year order.So its taking bydefault this format.But for webportal its not.
Thank you for being a part of Microsoft Family.
Thanks & Regards,
Microsoft O365 Support Team
David Cooper commented
Where is this upto product team? It’s becoming difficult to stop people using trello and keep going with this product. A requirement that should have been built into the product seems to be a disaster. It’s now nearly 3.5 years since this issue was raised. It would be great to get regular updates on this.
Paul B commented
All works fine for me until I use the 'open in planner function' from the ToDo app. I can see no locale settings in ToDo but it seems to have the correct date formats for the UK within the app. The issue comes about on this occasion because the way the URL is formatted by ToDo. It creates a URL with EN-US in it. While you allow Planner date setting to be governed by a URL you will always need developers to build additional complexity into all apps that form links to Planner to ensure the link is formatted correctly. Surely the answer for planner and all MS apps is to take the locale settings from the local machine? As a user, I don't want to have to adjust locale settings for each MS app that I use. Especially as the MS user interface is not consistent across apps and users are forced to hunt around in each app to find out where the apps developers have decided to hide them.
I am seeing the US date format when I export planner tasks to excel. I also note that the text format is not set to date for date columns when I export them to excel. Please allow for international date format throughout all of planner.