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.