>>I know I have this one somewhere in my code but I can't find it. Basically, the goal consists of doing a query and have a condition which implies a calculation on two fields. For example, I need to get all the records where AddDate+NumberOfDay would be less than today.
>
>

>...
>  WHERE AddDate+NumberOfDay < DATEADD(day, DATEDIFF(day, 0, getdate()), 0)
>

Check Operand type clash: date is incompatible with int error when trying to do +1 on a date data type in SQL Server 2008