On 9 Jul 2009, at 11:20, Aage Johansen wrote:

> 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.

Best regards,
________________________________________________________
Richard Wesley Senior Software Developer Tableau
Software
Visit: http://www.trytableau.com/now.html