1> -- Difference in weeks between 7-2-1996 and 8-4-1997? 2> 3> SELECT DATEDIFF(week, '7-2-1996', '8-4-1997') 4> GO ----------- 57 (1 rows affected) 1>