Hi Carol

May be a bit buggy but how about something along these lines

-------------------
declare @Date1 as datetime
declare @Date2 as datetime

Set @Date1 = '06/01/2005'
Set @Date2 = '01/01/2006'

select ((datepart(dy, @Date2) + (datepart(yyyy, @Date2)* 365)) -
(datepart(dy, @Date1) + (datepart(yyyy, @Date1)* 365))) / 365

-------------------

Thanks
Pat

MS Sql Server LazyDBA home page