DateTime report parameter

[Caner Mollaoglu]

Hello again,

First of all thanx for all your helps. I'm gonna ask a question.

I have a RDL report. I'm using some kind of parameters all works fine but the datetime parameter doesn't. I sent you a print screen which summarize my trouble and also I write it down here:

There is a datetime parameter as I said, I choose it and the rdl report works a stored procedure with using this datetime parameter. But I think that the format of the datetime parameter is not proper to use my sql query.

Could you please help me?

Thank you.

Attachment: rdlreportdateproblem_8e1faba2.rar

[Yuvaraj Devarajan]

Hi Caner, 

Yes, the mentioned problem happens due to different date format used for query filter. Our parameter dropdown component will render based on machine culture, hence the parameter date format is different from SQL date format. To overcome this problem, we request you to convert the date value of the parameter in query text using “Convert()” function as shown in below screenshot. 

 

Please find the below MSDN documentation for more detail, 

https://docs.microsoft.com/en-us/sql/t-sql/functions/cast-and-convert-transact-sql  

https://www.w3schools.com/sql/func_convert.asp  

Regards, 

Yuvaraj D.