calculate age

  • Thread starter Thread starter george
  • Start date Start date
G

george

Hi to all,
I'm looking for a CalculateAge function that adds a year
to the person's age six months after his or her birthday
so that someone born on June 1st 1964 (age 40 today) would
turn 41 on December 1st 2004 and 42 on December 1st 2005.
I'll appreciate any suggestions.
Thanks, George
 
George

It sounds like you want two things ...

What is the date six months after DOB?

What is the number of years between two dates (DOB and ????)?

Plus, you want to add "1" to number of years if the ???? date is after the
"six months after" date.

Take a look at DateAdd() and DateDiff() functions.

You could use these, plus the IIF() function, in a query to do your
calculation. Or you could build a function to do the same.
 
Back
Top