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
282 comments
-
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?
-
Anonymous
commented
This is also a problem in french. We should be able to select the regional settings to be used just like in Windows, or simply offer by default the same settings than Windows.
-
Khalid sarab
commented
Still not working, could we have an update on this please? only way we can achieve this at the moment is giving users a URL to planner with 'en-GB', but this is not ideal.
-
Sashi
commented
please fix it , we are unable to change the date format
-
Anonymous
commented
Can confirm that this is not fixed and remains in the US date format on the Planner Bd when this is set correctly at tenant level - please reopen and resolve
-
Joe McGiven Corban
commented
Agree, this isn't working for us in NZ either. I updated my own personal Regional settings via Delve, but still no luck - that is, whenever you click Planner from the apps menu it will load en-US (referring to Browser, not Teams).
The default for all should be based on what the Tenant setting is, and this cascades down.
-
Martin Vines
commented
This is still not fixed. Please could we have an update on an expected fix date
-
Simon Hunter
commented
this isn't completed? it's all US for me and no way to change it...