Operand type clash: datetime2 is incompatible with int (Between)
Try:
BETWEEN '2012-05-28' AND '2012-06-08'Otherwise it's 2012 minus 05 minus 28, which equals 1979 and is an integer and not a date.
Try:
BETWEEN '2012-05-28' AND '2012-06-08'Otherwise it's 2012 minus 05 minus 28, which equals 1979 and is an integer and not a date.