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
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."
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_sharepoint-mso_win10-mso_o365b/forms-date-format-correct-until-the-form-is/cc8138e5-f1dc-4e9d-b27a-b3b7a86f080f
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?
- Samuel WalkerApr 21, 2020Brass Contributor
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.
- Mike WilliamsApr 21, 2020Iron Contributor
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.