05-21-2019 10:07 PM
05-21-2019 10:07 PM
Does anyone know a way to switch the date format to dd/MM/yyyy in Forms? We have numerous business uses for Forms, and have signed up for the Forms Pro preview, but not being able to change the date format is an issue for us.
05-21-2019 11:57 PMSolution
05-23-2019 09:30 AM - edited 05-23-2019 10:11 AM
05-23-2019 03:28 PM
@Rob Elliott wrote:
@PaulaSillars this must be something to do with the regional settings made by Office 365 global admins because all our dates in Microsoft Forms are in dd/mm/yyyy format by default.
@Rob Elliott I am the global admin and I don't see anything in the Admin Center for regional settings other than the location of my tenant which is set to Australia which is correct.
Other applications including Sharepoint and OneDrive have the correct date formats and language settings, so far the only app with the US date formats issue is Forms.
09-03-2019 11:36 PM
@Christopher Hoard Please vote for this so hopefully, it reaches to thousands and MS team consider it
11-22-2019 02:02 AM
I know this is an old thread, but as someone new to forms, I spent a frustrating 30 minutes trying to figure out how to get the date format to show as dd/mm/yyyy. I followed instructions on changing my regional settings in Office 365 to no avail but eventually figured out what the problem was on my PC.
I use 2 browsers, Chrome and Chromium, I opened a shared form in Chrome, date format was in dd/mm/yyyy. As I'm just starting to learn about forms, I decided to recreate the form as practice - but on my form, the date format was m/d/yyyy. No regional settings with office would change this.
What was the difference? I was creating my own form in the Chromium browser, the one I was copying was opened in Chrome. If I opened my one in Chrome, date format was dd/mm/yyyy. Open it or the shared one in Chromium - date format m/d/yyyy.
It was the browser's regional settings that were giving me the US date format!!
Went into Chromium settings, People, Advanced, changed language from US to English (United Kingdom), removed the US language and now my date format was showing dd/mm/yyyy.
I still think it's a bit silly not to simply have an option to change the format within forms, but hopefully this will help someone else having the same issue!
12-13-2019 03:30 PM - edited 01-06-2020 04:59 PM
Forms dates are due to your browser language/locale settings. (Every browser describes and scopes these differently.)
12-15-2019 02:57 PM
@Mike Williams - wow this is the first reference I have seen to it being the browser and I can confirm that my Chrome was set to US instead of Australia and switching it fixed it.
Forms has been the only thing we have ever found that uses this (so far).
Thank you very much!
12-15-2019 04:37 PM - edited 12-15-2019 04:37 PM
@PaulaSillars It's a perennial problem. I have suggested to a couple of IT departments that they use group policy to set up all the standard browsers on provisioned computers with English(Australia) locale rather than default US but none have followed up :-(. It would save a lot of tickets to helpdesks.
01-06-2020 03:35 PM - edited 01-06-2020 03:36 PM
That doesn't change the date formatting. It only changes the wording of some app-generated text in the forms. It's more akin to the proofing language settings in Word/Office that are independent of the locale settings that determine date etc.
02-02-2020 09:52 PM
If you use the Forms with a direct link, it will follow the format of the default language on the browsers.
In Australia, when you install Chrome or the new Edge, the browsers will have US English as default.
So we changed all pcs Browsers to Australian English.... but..... If you try to use the form in a modern sharepoint site webpart, it will only show with the american format, no matter what settings you have in admin, site settings, etc.
02-02-2020 09:55 PM
02-03-2020 12:19 PM
@APC-andre Yes - it's extremely frustrating to set a sit collection's regional settings to something other than US English only to find that most of the dates rendered inside the collection ignore the regional setting.
Re the new Edge. I filed a bug about it ignoring both the user locale and the language settings of the existing default browser at install time. I received a notification that a fix for this is coming. However this is only the tip of the iceberg in terms of date issues in Microsoft Online products. If the environments are simply going to ignore your settings, then what can you do.
02-10-2020 02:59 PM
There is a solution to the forms on the modern SharePoint sites.
you will have to use the embed Web Part with iframe and change the browser language to UK/Australia/etc English.
Just have to play with the height.
"<iframe width="800px" height="1500px" src="https://forms.office.com/Pages/ResponsePage.aspx?id=FORMID&embed=true" frameborder="0" allowfullscreen="" style="border: none; max-width: 100%; max-height: 100%;"> </iframe>"
02-10-2020 03:13 PM
@APC-andre That is not a solution: changing the browser locale is required for every Forms deployment, and is non-trivial. [NB language and locale are distinct properties: the former relates to UI text, and the former to measured units like time, distance and temperature]
There are also parts of SharePoint that respect neither the site collection locale nor the browser locale setting.
04-17-2020 01:33 AM
Hi there - this isn't the answer. The problem apparently is caused by the location of the Forms servers:-
"We took a long time to reply because we also tested at our end. After we changed the time zone and date format in Delve, then we checked the date format in Forms. The date format in Forms didn’t change to UK nor the Forms Web Part.
As the data of Forms are store in servers in the United States, I assume that is the reason why we can’t change the format even we change the time zone or region."
04-20-2020 11:05 PM
@Samuel Walker Hi Samuel. The linked " I assume that is the reason" opinion is incorrect. In Australia all our Microsoft data is hosted here and that has no impact on Forms dates. It's all about the browser settings which i have tested extensively across Chrome, Firefox and Edge. Have you checked yours?
04-21-2020 03:18 AM
Hi Mike - the opinion is that of a Microsoft agent - are you saying she's wrong? I think you may be right.
I have set the locale settings on both Forms and on the Sharepoint site - dates in each display correctly (for the most part - Sharepoint seems a bit inconsistent in this regard).
It is only when the Form is embedded in Sharepoint that it shows incorrectly.
Another user in the thread I linked to has commented that (bold my own):-
Also SharePoint is completely inconsistent with dates. Even if you go into Site Settings and set your locale to English(UK) or English(Australia) so that most dates are formatted as dd/mm/yyyy, you can go to your listing of subsites (_layouts/15/viewlsts.aspx?view=15) and see that all the creation dates are mm/dd/yyyy. There are lots of places where mm/dd/yyyy seems to be hard-coded through SharePoint.
This is the answer most consistent with what I have observed.
04-21-2020 04:12 PM - edited 04-21-2020 04:12 PM
@Samuel Walker The Microsoft agent wrote "I assume" and I generally find their assumptions around international issues to be poorly-based. I at least have a lot of direct experience and evidence which I have raised with Microsoft directly. The more people that do that the better. There are too many old and well-supported User Voice tickets around international issues which are not getting Microsoft attention.
by Matt Sikorski on August 28, 2018