Find the number of days between 24th March 2001 and 24th March 1964
1> -- Find the number of days between 24th March 2001 and 24th March 1964 using 2> 3> SELECT DATEDIFF(dd, "24 March 2001","24 March 1964") 4> GO ----------- -13514 (1 rows affected) 1>