US Date format on Parameter input box

[SQLSi]

Is there a way to change the text input boxes for report parameters to accept dates in UK format.  They report invalid date when attempting to use e.g. 20/01/2020 and instead want to force it to use MM/dd/yyyy (US Format).

I've double checked all region / locale and browser (Chrome) language settings inclduing the PBIX global and file settings to ensure they're all British English and United Kingdom.

[Anonymous]

Hi @SQLSi ,

I'm afraid it's set up to be unchangeable. However, you can change the parameters to text instead of date.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AllardBon]

Hi Jay,

The problem is that when you change the parameter from datetime to text, the date-picker disappears. Many users want to choose between date-picker and manual input. When the parameter-format is datetime, the manual input 01-10-2023 (oktober 1st) changes automatically to 10-01-2023 (januari 10th). Outside the US the world uses DD-MM-YYYY instead of MM-DD-YYYY. Please make this regional-dependent, Microsoft-team! 

[Anonymous]

hi Jay,

How do we get microsoft to fix this for the 90% of the world that isnt the U.S.
Im in Australia and have the same problem and it annoys my users no end 

Mickeal