Birthdate Calculation

[Randy]

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,

 

[tina]

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]

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

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

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,

 

[tina]

you're very welcome

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

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

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,

 

[Jess Martyn]

Hello,

Recently, http://extremedesigners.5u.com - A website about web designing -
has been launched. I would like you to take a look at it and pass your
suggestions - complements - about it.

- Regards,
Extreme Designing Team.