• Heres how to calculate an age

    select CASE

    WHEN dateadd(year, datediff (year, d1, d2), d1) > d2

    THEN datediff (year, d1, d2) - 1

    ELSE datediff (year, d1, d2)

    END as Age

    I'll take a look at the rounding issue though...



    Clear Sky SQL
    My Blog[/url]