Take a look at the DATEDIFF() function: http://technet.microsoft.com/en-us/library/ms189794(v=sql.105).aspx

DATEDIFF ( datepart , startdate , enddate )

HTH,

Rob