I have a datawindow for report which has an argument of datatype DATETIME, and datasource as SQL Server 2019. The argument is related to table column of datatype datetime2. When I try to retrieve the report, I get an error as :
When I try to convert the argument datatype of DATETIME using CAST or CONVERT functions, I get the error as below :
I am pretty much stuck over here and getting any solution.
Does anyone know this issue?
Thanks and regards,
Santosh Natal