Hi all,

I am running a simple DATEDIFF query but it doesn't seem to calculate the days properly or i'm doing something wrong.

If I run

PRINT DATEDIFF(Day, 2010-01-20, 2010-01-01)
RETURN 19

Which is correct. If i change the month in the first date to Feb (02) I get something strange.

PRINT DATEDIFF(Day, 2010-02-20, 2010-01-01)
RETURN 20

Now shouldn't it be 48 or something?

Can anyone see what i'm doing wrong or is this not the correct function to be using if I want the No of days between these dates?

I've tried taking one date from the other:

PRINT (2010-02-20) - (2010-01-01)
RETURN -20

Any help much appreciated.

Thanks J.