calculate age

[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

 

[Jeff Boyce]

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.