Richard,

> > I understand what happens, but I had hoped for a function that would
> > return 0 months (i.e. less than 1 month) and 1 year (i.e. "1 <=
> > result < 2"). What I really need is to find "age" expressed as
> > "completed years" between two dates.
>
> Truncate the dates to the first of the year and use datediff(year on
> them.

How would you "truncate" the dates?


Sean