I have created a report that uses SSRS into SQL Server 2019 being used via browser.
The problem is that the database and initial values from the widget all pass correctly in "dd-mm-yyyy" format and it all works. The problem happens if you then change the date.
It seems that after the initial selection, any later selections are passed as "yyyy-mm-dd" format resulting in a type mismatch.
Is there some parameter I am missing that results in this format change?
Thanks