Forum Discussion
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 ...
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
Advocate I
Advocate IHi 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!