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]))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to add time to date? 5
Turning off automatic calculation 0
Calculating age with If statement 2
age rounding up or down 3
Automatically calculate age from birthdate 2
MS Word Merge fields 0
annual birthdate for the current month 1
query birthdates occuring in year range 2

Top