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
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.
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?
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?
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.
please fix it , we are unable to change the date format
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...
The date format of Planner when viewing in Teams can be changed. In the Teams desktop client, click on your photo and select Settings (cog), then on the General tab you will see Language. Change the first entry of App Language determines the date and time format to your locale.
Thanks Microsoft for fixing, but please try to: 1 - be better with your defaults as most people aren't in the USA. 2 - educate everyone on where to change settings, this was hard to find
Still an issue in Australia. Makes Planner far less useful and straightforward
Please fix this, it creates massive issues for us.