How can we make Planner better?

← Microsoft Planner - Feedback Forum

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

1,598 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
In development  ·  AdminPlanner Team (Product Manager, Planner) responded  · 

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

Show previous admin responses (2)

319 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Gilles Couzin commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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:

    refer: https://planner.uservoice.com/forums/330525-microsoft-planner-feedback-forum/suggestions/13688679-date-format

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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

  • David Cooper commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Robert commented  ·   ·  Flag as inappropriate

    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

1 2 4 6 … 15 16

Microsoft Planner - Feedback Forum: General

Categories

Feedback and Knowledge Base

(thinking…)