By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,491 Members | 879 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,491 IT Pros & Developers. It's quick & easy.

Calculated field with age

P: n/a
I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I would like to
put a calculated field that shows the age of that particular person,
calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john
Aug 26 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

"john" <jo**@test.comschreef in bericht news:T8********************@casema.nl...
I've searched google but can't find what I need.
?????
How did you search ?? This question has been asked and answered lots of times...

http://groups.google.com/group/comp....ulation&qt_g=1

Arno R
Aug 26 '06 #2

P: n/a
"john" <jo**@test.comwrote in
news:T8********************@casema.nl:
I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I
would like to put a calculated field that shows the age of
that particular person, calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john
age = datediff("yyyy",dob,date())
for a more accurate age, use the reknowned Allen Browne's age()
function which handles a subtle error in the expression I wrote
above. It also lets you specify a date different from today if you
need to.
http://allenbrowne.com/func-08.html
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com

Aug 26 '06 #3

P: n/a
I found so many pages on 'access age calculated field', but not the one I
was looking for.
john

"Arno R" <ar***********@tiscali.nlschreef in bericht
news:44**********************@text.nova.planet.nl. ..

"john" <jo**@test.comschreef in bericht
news:T8********************@casema.nl...
I've searched google but can't find what I need.
?????
How did you search ?? This question has been asked and answered lots of
times...

http://groups.google.com/group/comp....ulation&qt_g=1

Arno R
Aug 26 '06 #4

P: n/a
"Bob Quintal" <rq******@sPAmpatico.caschreef in bericht
news:Xn**********************@66.150.105.47...
"john" <jo**@test.comwrote in
news:T8********************@casema.nl:
>I've searched google but can't find what I need.
In my form I have a field Date Of Birth. Netxt to that field I
would like to put a calculated field that shows the age of
that particular person, calculated from today.
What's the easiest way of doing this?
Thanks in advance,
john

age = datediff("yyyy",dob,date())
for a more accurate age, use the reknowned Allen Browne's age()
function which handles a subtle error in the expression I wrote
above. It also lets you specify a date different from today if you
need to.
http://allenbrowne.com/func-08.html
--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com
Thanks!
john
Aug 26 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.