Forum Discussion
Date Formatting
- May 22, 2019Hi!
There are multiple uservoices open for this here including
https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/37496209-date-format
https://microsoftforms.uservoice.com/forums/386451-welcome-to-microsoft-forms-suggestion-box/suggestions/18409984-allow-uk-date-format-in-forms-please
Would recommend you vote for them - fast becoming one of the top requests and annoyances about Forms. I think Microsoft will pick this up in time.
Hope that answers your question!
Best, Chris
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
Los Gallardos
- APC-andreFeb 03, 2020Copper Contributor
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. - Mike WilliamsDec 13, 2019Iron Contributor
Forms dates are due to your browser language/locale settings. (Every browser describes and scopes these differently.)
- PaulaSillarsDec 15, 2019Iron Contributor
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!
- Mike WilliamsDec 16, 2019Iron Contributor
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.
- PaulaSillarsMay 23, 2019Iron Contributor
RobElliott 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
Los GallardosRobElliott 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.
- APC-andreFeb 03, 2020Copper ContributorIf you have the forms with a direct link to them or inside a classic sharepoint site, you will have to change the browser default language in settings.
If you try to use a form inside a modern sharepoint site with a Forms webpart, forget about it, it will only show with US date format.- Mike WilliamsFeb 03, 2020Iron Contributor
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.
- May 23, 2019Hmm may have been introduced recently if that is the case may be locale settings in the user profile too
https://support.office.com/en-us/article/change-your-display-language-and-time-zone-in-office-365-for-business-6f238bff-5252-441e-b32b-655d5d85d15b
If I don’t hear back I will test tomorrow to once back in the office.
Best, Chris- PaulaSillarsMay 23, 2019Iron Contributor
ChrisHoardMVP It's definitely got me a bit confused, I appreciate your help.