Out-of-range value in data type

[emacon]

Hello, I'm trying to create a report in Stimulsoft. I've already created others, and I've never encountered this kind of issue before. Here's the query for the data source:

Code: Select all

SELECT *
	FROM vwMovimenti
	WHERE data_movimento between '{Da_Data_Movimento}' and '{a_Data_Movimento}'
    AND descrizione_divisione = '{Divisione}'
	AND codice_causale = '{Causale_1}' or codice_causale = '{Causale_2}'

Given that:
Da_Data_Movimento is a datetime and is a parameter in Stimulsoft.
a_Data_Movimento is a datetime and is a parameter in Stimulsoft.
data_movimento is a datetime and is a column in the table.

What could be the reason for encountering the following error at runtime?:
"The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."

I can't seem to figure out what the problem might be... I've applied this type of filter using parameters in other reports with the same data types, and I've never encountered this error before. It would be greatly appreciated if you could help me out with this. Thank you.

[Lech Kulikowski]

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.