Change date format for tasks
The date format (e.g. dd-mm-yyyy instead of mm-dd-yyyy) set in the general preferences should also be valid for the dates set for tasks within Project. From what I can see the date format for tasks are always mm-dd-yyyy which is annoying.
This is very confusing especially for those users outside USA, keep changing the URL to include EN-GB is a workaround, but is very painful when need to keep doing it time over time.
The date format option of the MS Project desktop application is broken since version 1.0.
The web application only follows this.
Just think about this: Word and Excel have full customization of date fields. Just enter this "YYYY-mm-dd" and you are done.
But the project planning app (where the correct display of dates is the MOST IMPORTANT POINT) ignore this since 20+ years.
Please please please fix this. Makes Project almost useless outside the US...
Hi guys. It seems what controls this is the field PEX endpoint in Project Parameters which contains this.
The <lang> part seems to be determined by the language setting (Keyboard?) of your PC. If this is set to English United Kingdom you get DD/MM/YYYY. English USA gives you MM/DD/YYYY. Alternatively with some fiddling in config you can set this to:https://project.microsoft.com/en-GB/?org=<cdsServer>#/taskgrid?projectId=<id>&type=2 which hard-codes the language. I am not sure whether this has another impact.
Microsoft 365 geek commented
This is Utter Nonsense, Microsoft is overlooking the fact that they have customer base outside US and not everyone uses this trash date format MM/DD/YYYY. If you contact the support they will give you the URL hack and would ask you to vote here or change the time zone from Admin center.
BREAKING NEWS FOR MICROSOFT
I am already in the correct Time Zone, your Product isn't.
Change date format for tasks in project online
The date format (e.g. dd-mmm-yy instead of mm-dd-yyyy) set in the general preferences should also be valid for the dates set for tasks within Project. From what I can see the date format for tasks are always mm-dd-yyyy which is annoying.
Robert H commented
Seriously - when will this be fixed?
I am in Australia, and while to URL hack works - its not good.
Daniel Merriott commented
I’ve been doing further investigation, it looks like the following is happening:
(a) the web app seems to completely ignore the user profile preferences set in the Microsoft365 account profile
(b) the regional date/time format used is determined by the URL … so project.microsoft.com/en-US will show US format, project.microsoft.com/en-GB will show UK format, etc
(c) the user can manually override this by changing the language slug in the URL
(d) the redirect from project.microsoft.com to /en-US, /en-GB, /en-NZ, etc is appears to be determined by the browser language settings
(a) It appears the URL for link in the Office365 Launcher defaults to /en-US for English language users, except for a limited set of other English languages regional settings
Example: with my browser language set to English (New Zealand) the URL is /en-US (not /en-NZ)
Example: with my browser language set to English (United Kingdom) the URL is /en-GB
(a) Date formats in Teams ignores the user profile preferences set in the Microsoft365 account profile
(b) The regional date/time format used is determined by (1) the browser language when using the webapp, (2) the application language when using the desktop app.
(c) The desktop app language settings appear to be independent of the Windows user language settings and default (at least for English language systems) to English (United States).
So it appears the underlying issue is inconsistent handling of regional language preferences with some M365 apps/webapps, specifically Teams and project.microsoft.com which are ignoring the user preferences set in Microsoft365 or in Windows.
This is compounded somewhat by Microsoft (and others) assuming that the default for English is to use the US preferred regional setting of MM/dd/yyyy, when the majority of non-US English speaking countries (as best I can tell) use the international dd/MM/yyyy – with en-NZ being an example of this being set incorrectly.
A workaround is available:
Users can change the regional language settings in their browser to English (United Kingdom) and in the Teams app to English (United Kingdom). There may be other language settings where the correct dd/MM/yyyy is available, I haven’t exhaustively checked.
The workaround is not perfect and requires every user to update every device/browser to use English (United Kingdom) instead of their local variety of English. It should be noted that changing this in browser that may have some unintended knock-on effects as some websites use the primary language and regional settings from the browser to redirect to a country specific version of the site or to determine the currency to be displayed… Naturally not many users outside the UK would want to see pricing in GBP instead of their local currency if a website is picking up on the browser preferred language/regional settings.
Daniel Merriott commented
I'm in NZ. Date format defaults to US.
The Link in the launcher explictly takes me to project.microsoft.com/en-US.
If I just visit the URL project.microsoft.com I'm redirected to /en-NZ where Microsoft still shows me the US format MM/dd/yyyy (hint to Microsoft, almost no-one outside the US uses dd/MM/yyyy).
This is despite my display language, language preference and regional date format being set in my profile as English (United Kingdom).
If I change the URL to /en-GB I get the correct format, however it seems that when I embed into Teams it defaults back to the US format.
I see two problems here: (1) Microsoft have the wrong date format for en-NZ universally (hence setting my language to en-GB). (2) Project is ignoring the account preferences and defaulting to show whatever language they think is best.
Why is this still not fixed. This is insane. Project management software where you can't rely on the date format is utterly worthless. Stop using agile development practices for literally everything and actually get your MVP sorted before going to market.
The URL hack works for me in Aus but we use project through Teams which means I cant use the workaround in the Project Tab.
Is there something we are missing here? Is there a setting we are missing or is it just that hardly anyone using the app?
I can't believe this. I'm in Australia. If I use US dates, no one will know what I'm on about.
Tajinder Jagdev commented
Try changing the language to UK English and see if that helps with date format. It worked for me.
there must be way to set custome date format its shocking that i cant change date format to DD-MON-YYYY format ... rubbish
WHY OH WHY Microsoft do you insist on using the INCORRECT date format!! MM/DD/YYYY is only used by the US, please allow your programs to be able to adjust to regional settings
There is a solution, for some countries at least. It was hinted at in the January 27 Admin comment.
Change the url to https://project.microsoft.com/en-AU/...... and the date format seems to be in dd/mm/yyyy format. You may need to change view (e.g. to timeline and back) for it to take effect.
Bizarely, en-UK doesn't work, so you'll have to be honorary Aussies.
Not sure about other countries.
Is it really true that ONLY the arcane US date format can be set? Unbelievable. In this day and age, where dd/mm/yyyy is used in most of the world. No wonder I don't like Microsoft....
Kenneth Madsen commented
Add some basic date/time functionality to the MS Project Web and allow the user to set up date format as needed. Currently it is locked to MM/DD/YYYY, which is probably great for US but less so for other places.
Please change it. I'm in Germany. It annoys me, too. This is prone to result in errors.
ISA (UK) commented
I can go into my account and change the date format to a non US DD/MM/YYYY but in MS Project Online it remains the VERY confusing MM/DD/YYYY.
I've go to say that this online version of Project seems to be a dog. Unless it's me? I just can't get my head around having no visual cues / buttons etc., and then stupid issues like not being able to show dates in the expected way in PROJECT MANAGEMENT SOFTWARE. Never, rated MS and this 'squidgy, smelly brown stuff' only confirms my feeling that the biggest software seller in the world, still can't build remotely adequate products. Or maybe it's just me.