Skip to Content
0
Feb 10, 2012 at 07:57 AM

Problem on Query Generator

24 Views

Hi Expert,

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?

Thanks...

ArlmiPJ