Forum Discussion

SQLSi's avatar
SQLSi
New Member
6 years ago

US Date format on Parameter input box

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.

 

 

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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 

    • AllardBon's avatar
      AllardBon
      Advocate I
      3 years ago

      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!