Birthdate Calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all...
I have created (or at least attempted) a birthdate calculation of sort that
will (should) calculate the age of an individual by entering the birthdate
into a field. What is hppening is when I enter the birthdate the calculation
works but seems to be rounding the age. Ie; I enter 5/26/96 and get a
returned age of nine (9) when in actuallity it should be eight (8) as this
indivdual has not yet turned nine (9).

Is there a way to et the actual age?

This is what I have now: =DateDiff("yyyy",[Birthdate],Date())

Any suggestions would be greatly appreciated. I Thank you in advance for
your time,
 
Thanks Tina...Worked like a charm! You are my hero!

tina said:
take a look at

http://www.mvps.org/access/datetime/date0001.htm

the mvps.org website is a must-have in your Favorites folder, you'll find
tons of great info there.

btw, we're neighbors (Riverside)! :)


Randy said:
Hello all...
I have created (or at least attempted) a birthdate calculation of sort that
will (should) calculate the age of an individual by entering the birthdate
into a field. What is hppening is when I enter the birthdate the calculation
works but seems to be rounding the age. Ie; I enter 5/26/96 and get a
returned age of nine (9) when in actuallity it should be eight (8) as this
indivdual has not yet turned nine (9).

Is there a way to et the actual age?

This is what I have now: =DateDiff("yyyy",[Birthdate],Date())

Any suggestions would be greatly appreciated. I Thank you in advance for
your time,
Click to expand...
Click to expand...
 
you're very welcome :)


Randy said:
Thanks Tina...Worked like a charm! You are my hero!

tina said:
take a look at

http://www.mvps.org/access/datetime/date0001.htm

the mvps.org website is a must-have in your Favorites folder, you'll find
tons of great info there.

btw, we're neighbors (Riverside)! :)


Randy said:
Hello all...
I have created (or at least attempted) a birthdate calculation of sort that
will (should) calculate the age of an individual by entering the birthdate
into a field. What is hppening is when I enter the birthdate the calculation
works but seems to be rounding the age. Ie; I enter 5/26/96 and get a
returned age of nine (9) when in actuallity it should be eight (8) as this
indivdual has not yet turned nine (9).

Is there a way to et the actual age?

This is what I have now: =DateDiff("yyyy",[Birthdate],Date())

Any suggestions would be greatly appreciated. I Thank you in advance for
your time,
Click to expand...
Click to expand...
Click to expand...
 
Back
Top