birthdate calculation - help

J

Jim Allensworth

I would like to be able to calculate birthdate in a query
Click to expand...

Uhh, that's not a calculation.

We are born when we are born. Although, some of us would like to
advance that date at times ;-)

- Jim

Ok, maybe a little more info.
 
J

John Vinson

I would like to be able to calculate birthdate in a query
Click to expand...

calculate it... from what?

If you mean that you want to calculate this year's birthday
anniversary date given a stored date of birth field in your table, you
can use an expression:

HappyHappy: DateSerial(Year(Date()), Month([DOB]), Day([DOB]))
 
Top