Answered

Date picker format in Forms

Like (0) Share

Report

Posted on 16 Dec 2019 11:58:34 by Community Power Pla...

I am using Forms in my personal O365 account and when I setup a date picker it defaults to the US format of dd/mm/yyyy instead of what I need which is dd/mm/yyyy. My Office 365 account is set to the location of Australia and English is set to English (US) when I set it to English (UK) it doesn't affect the date picker

Can someone help please?

I have the same question (0)

All responses (6)

Answers (2)

manuelstgomes 6,625 on 16 Dec 2019 at 14:35:52

Like (0)

Report

Re: Date picker format in Forms

HI @Anonymous

I think the calendar picker picks up the browser settings and not the O365..

But O365 mingles a little bit the configurations. My instance shows up content in English and Portuguese and PT and US regional settings. Honestly it's tricky. For example here's my calendar in a form:

Control is tricky but could you please try to check if, changing your regional settings in your browser / OS, it changes?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... on 17 Dec 2019 at 02:41:33

Like (0)

Report
Re: Date picker format in Forms

As you can see above the browser settings (not my PC settings which are in the correct region and date format) are clearly causing the problem. Also it doesn't matter what the browser setting is when you create the form, it matters what browser you are using to view and complete the form as both change when using different browsers.

Firefox (setting correct)
Microsoft Internet Explorer 7 (correct date format)
Microsoft internet Explorer for Windows 10 (correct date format)
Microsoft Edge Beta (Chromium) (incorrect date format)
Problem is I don't know where in the browsers you set the date format.
As others who are using the form are seeing the incorrect date format so I need to know where the settings are.
Either all of the browsers above are honouring my PC system settings except Edge Beta or I am missing where the date format is. When I look at IE7 it appears to use the PC region/date settings but its not obvious in any of the other browsers

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on 17 Dec 2019 at 06:46:48

Like (0)

Report

Re: Date picker format in Forms

Hi @Anonymous ,

Does this date format have any effect on your creation of Flow? If so, please let us know.

If it has no effect on the creation of Flow, but it has caused you trouble, I recommend you to submit your question to the MS Forms community, where you can get more detailed answers:

https://techcommunity.microsoft.com/t5/Microsoft-Forms/ct-p/MicrosoftForms

Best Regards,

Was this reply helpful? Yes No
Verified answer

manuelstgomes 6,625 on 17 Dec 2019 at 09:56:28

Like (1)

Report

Re: Date picker format in Forms

HI @Anonymous

Yeah, it's a mess, I know. I get complaints like this, but I warn people to double-check. I think this is something that Microsoft needs to address and fix, or at least provide clear guidelines on where the settings are fetched.

I recommend submitting an idea here:
https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/FlowIdeas

Sorry, I can't help more, but as you pointed out, this is something that needs to be fixed.

I hope this helps.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Cheers
Manuel

Was this reply helpful? Yes No
Community Power Pla... on 28 Dec 2019 at 11:46:50

Like (0)

Report

Re: Date picker format in Forms

Thanks, it is forms related so will do as suggested (couldn't find the forms forum) thanks for the link.

Was this reply helpful? Yes No
Community Power Pla... on 28 Dec 2019 at 11:47:41

Like (0)

Report

Re: Date picker format in Forms

Thanks.

Was this reply helpful? Yes No