I made the following query:
SELECT T0.[RefDate], T0.[TransId], T1.[Account], T1.[ShortName], T1.[Debit], T1.[Credit], T1.[ProfitCode] FROM OJDT T0 INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId WHERE T0.[RefDate] between [%0] and [%1]
However error log appears as follows:
1). [Microsoft][SQL Native Client][SQL Server]Arithmetic overflow error converting expression to data type datetime. 'User-Defined Values' (CSHS)
Can you please figure out how to solve this problem?