SSRS issue matching date with parameters

Question

I have a SSRS report using an ODBC connection with MySQL. I have a problem to match the date with the parameters. When I type a date manually in the query it works fine, no problem. But when I use the parameters, it doesn't return anything. One thing I found is that the date data returned is under the format YYYY-MM-DD and the date from parameter is DD/MM/YYYY. I tried CONVERT and STRING_TO_DATE functions of MySQL but no luck. Any clue?

Check this out - social.msdn.microsoft.com/Forums/sqlserver/en-US/… — Joe C
I was able to retrieve data when the date is equal but BETWEEN or > signs don't work. " AND DATE_FORMAT(DON.DonDate,""%m/%e/%Y"") = '" & Parameters!DateDebut.Value & "'" — SQLiz

Ghaleb Badran Ghaleb Badran · Accepted Answer · 2017-11-19T22:50:45

convert the parameter value to a date based on the format sent from the SSRS to match the format you are using in the manual test.

Converting a date in MySQL from string field

SSRS issue matching date with parameters

1 Answers