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}'
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.