calculating age

  • Thread starter Thread starter Nancy
  • Start date Start date
N

Nancy

I have found an expression that can be used in a query to
calculate a person's age based on the date of birth and
the current date. The expression is:

=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now
(), "mmdd") < Format( [Birthdate], "mmdd") )

The problem is that I need the age in years + months
because I am using it for a dataset of children whose
ages must be calculated exactly. This expression gives
only the age in years. For example, I need "1 year and 2
months."

Can someone please help me modify the expression to get
the remaining months?

Thanks.
 
Back
Top