Date format
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
Thanks
Anonymous
shared this idea
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!
Thanks,
The Planner Team
329 comments
-
Adam
commented
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)
-
Anonymous
commented
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.
-
Anonymous
commented
''If you’re seeing this issue persist outside of Teams and your language/locale is set properly for your Office account" - still an issue!
-
Anonymous
commented
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 -
Anonymous
commented
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.
-
Paul
commented
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.
-
Anonymous
commented
Yes, still an issue. I am using Planmaker as a stand alone outside of teams.
-
Anonymous
commented
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.
Hi Admin,
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,
Sagar Awasare
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.
-
Anonymous
commented
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.
-
Jenny Brothers
commented
Correction, when I change the URL in my planner to 'EN-GB' it does change the date format
-
Jenny Brothers
commented
I've tried changing my URL and the settings in Teams but they don't filter through to my Planner app. Trying to get UK date format instead of US
-
Richard Olearczyk
commented
Not working for us in Queensland Australia - most infuriating
-
David Cooper
commented
Hi product group
We still have this issue see my comments once the original fix was released.
What does the following mean?
If you’re seeing this issue persist outside of Teams and your language/locale is set properly for your Office account?
Where in office, there are so many places that have their own date locale settings it’s a very broad statement. Can you be more precise than just office?
-
Sophie
commented
The date format is still in the US format for me so (as with lots of others) this doesn't seem to be completed. An update would be great if you have one?