Forum Discussion
Date Formatting
- Hi!
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 you can switch this by changing the primary language of the form. See screenshots below:
1. Click the three dot menu and select "Multilingual"
2. Select "English (United Kingdom)" as the Primary Language
All set!
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?
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.
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.
Mike Williams oh okay, it seems to work from me on the front end when submitting the form?
Paul_Limbers The date format you see is a function of your local browser/environment. It cannot be set by the form creator.
