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 ...
Need Help
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
    Icon for Advocate I rankAdvocate 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!