AGE DATE

[chris.snuggs]

This has apparently been done many times, but everything I've looked at
is either incomprehensible or simply doesn't work.

This doesn't work on my report: datediff("yyyy",[DOB],now())

Nor does this: =datediff("yyyy",[DOB],now())

Can anyone suggest why?

There are many other suggestions as to how to do this, but I can't get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.

[salad]

ch**********@isuga.fr wrote:

This has apparently been done many times, but everything I've looked at
is either incomprehensible or simply doesn't work.

This doesn't work on my report: datediff("yyyy",[DOB],now())

Nor does this: =datediff("yyyy",[DOB],now())

That one should work.

Is the DOB field empty?

You don't say what doesn't work so it's hard to determine what is wrong

>
Can anyone suggest why?

There are many other suggestions as to how to do this, but I can't get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.

[ManningFan]

Hard to tell what the problem is, but I can tell you right now you're
not always going to get an accurate answer using that formula. If the
date is Sept 9 and the person was born Oct 4, he's going to appear to
be a year older than he really is.

ch**********@isuga.fr wrote:

This has apparently been done many times, but everything I've looked at
is either incomprehensible or simply doesn't work.

This doesn't work on my report: datediff("yyyy",[DOB],now())

Nor does this: =datediff("yyyy",[DOB],now())

Can anyone suggest why?

There are many other suggestions as to how to do this, but I can't get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.

[Fred Zuckerman]

I use a function to display age:
(caution - air code)

Public Function Age(Bdate as date) as integer
Age = Year(Date) - Year(Bdate)
' Subtract 1 if subject hasn't yet had their birthday this year
If Format(Date,'mmdd') < Format(Bdate,'mmdd') Then
Age = Age - 1
Endif
End Function

Fred Zuckerman
"ManningFan" <ma********@gmail.comwrote in message
news:11*********************@i3g2000cwc.googlegrou ps.com...

Hard to tell what the problem is, but I can tell you right now you're
not always going to get an accurate answer using that formula. If the
date is Sept 9 and the person was born Oct 4, he's going to appear to
be a year older than he really is.

ch**********@isuga.fr wrote:

This has apparently been done many times, but everything I've looked at
is either incomprehensible or simply doesn't work.

This doesn't work on my report: datediff("yyyy",[DOB],now())

Nor does this: =datediff("yyyy",[DOB],now())

Can anyone suggest why?

There are many other suggestions as to how to do this, but I can't get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.

[Randy Harris]

On Fri, 08 Sep 2006 20:39:43 GMT, "Fred Zuckerman"
<Zu********@sbcglobal.netwrote:

>I use a function to display age:
(caution - air code)

Public Function Age(Bdate as date) as integer
Age = Year(Date) - Year(Bdate)
' Subtract 1 if subject hasn't yet had their birthday this year
If Format(Date,'mmdd') < Format(Bdate,'mmdd') Then
Age = Age - 1
Endif
End Function

Fred Zuckerman

Or, perhaps

Age=Year(Date) - Year(Bdate) + _
(DatePart("y",Date) < DatePart("y",Bdate))

-=-=-=-=-=-=-=-=-=-=-=-=
Randy Harris
tech at promail dot com

[Kc-Mass]

How about something simple like:

intAge = Int( (Now() - BDate) / 365 )
<ch**********@isuga.frwrote in message
news:11**********************@i42g2000cwa.googlegr oups.com...

This has apparently been done many times, but everything I've looked at
is either incomprehensible or simply doesn't work.

This doesn't work on my report: datediff("yyyy",[DOB],now())

Nor does this: =datediff("yyyy",[DOB],now())

Can anyone suggest why?

There are many other suggestions as to how to do this, but I can't get
any to work. I just want to enter the age in a report field based on
someone date of birth = DOB as fieldname.

[Arno R]

"Kc-Mass" <co********@comcast.netschreef in bericht news:BJ******************************@comcast.com. ..

How about something simple like:

intAge = Int( (Now() - BDate) / 365 )

Only if *every* year would have 365 days this would be a correct answer...

Arno R

[Armando]

"Arno R" <ar***********@tiscali.nlwrote in message
news:45**********************@text.nova.planet.nl. ..

intAge = Int( (Now() - BDate) / 365 )

Only if *every* year would have 365 days this would be a correct answer...

-----

Seems OK to me. By the time the error creeps in enough to kick that INT up
to the next number, a person would have to be over 700 years old (having
lived for over 183 leap years).

I could be wrong, though...

Armando

[Bob Quintal]

"Armando" <ar*****@bogus.comwrote in
news:ya*******************@news1.epix.net:

>
"Arno R" <ar***********@tiscali.nlwrote in message
news:45**********************@text.nova.planet.nl. ..

> intAge = Int( (Now() - BDate) / 365 )

Only if *every* year would have 365 days this would be a
correct answer...

-----

Seems OK to me. By the time the error creeps in enough to
kick that INT up to the next number, a person would have to be
over 700 years old (having lived for over 183 leap years).

I could be wrong, though...

Armando

testing your expression against age() at
http://www.mvps.org/access/datetime/date0001.htm,
with now() at 22/09/2006 6:37:03 PM

gives the first error
23/09/1996 (7302 days ago)
and subsequent errors at
25/09/1995 8030
24/09/1995 8032
23/09/1995 8034
25/09/1994 8760
24/09/1994 8762
23/09/1994 8764
25/09/1993 9490
24/09/1993 9492
23/09/1993 9494

I just looped to 10000 days.

--
Bob Quintal

PA is y I've altered my email address.

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

[Arno R]

"Armando" <ar*****@bogus.comschreef in bericht news:ya*******************@news1.epix.net...

"Arno R" <ar***********@tiscali.nlwrote in message
news:45**********************@text.nova.planet.nl. ..

> intAge = Int( (Now() - BDate) / 365 )

Only if *every* year would have 365 days this would be a correct answer...

-----

Seems OK to me. By the time the error creeps in enough to kick that INT up
to the next number, a person would have to be over 700 years old (having
lived for over 183 leap years).

I could be wrong, though...

Armando

You are wrong indeed.

Suppose my birthday is today and I was born 23-09-1951
Your function would say that I am 55 years old correct

Suppose my birthday was not today but tomorrow...
Your function would say that I am 55 years old wrong

Suppose my birthday was not today but 1day after tomorrow...
Your function would say that I am 55 years old wrong
Suppose my birthday was not today but 2days after tomorrow...
Your function would say that I am 55 years old wrong
Suppose my birthday was not today but 3days after tomorrow...
Your function would say that I am 55 years old wrong
Suppose my birthday was not today but 4days after tomorrow...
Your function would say that I am 55 years old wrong
Suppose my birthday was not today but 5days after tomorrow...
Your function would say that I am 55 years old wrong
Suppose my birthday was not today but 6days after tomorrow...
Your function would say that I am 55 years old wrong
....
Suppose my birthday was not today but 10days after tomorrow...
Your function would say that I am 55 years old wrong
....
For how many days your function will be wrong ???
Too many !!

This is a repeating issue EACH year !!

Arno R

[rquintal]

Arno R wrote:

"Armando" <ar*****@bogus.comschreef in bericht news:ya*******************@news1.epix.net...

"Arno R" <ar***********@tiscali.nlwrote in message
news:45**********************@text.nova.planet.nl. ..

intAge = Int( (Now() - BDate) / 365 )

Only if *every* year would have 365 days this would be a correct answer...

-----

Seems OK to me. By the time the error creeps in enough to kick that INT up
to the next number, a person would have to be over 700 years old (having
lived for over 183 leap years).

I could be wrong, though...

Armando

You are wrong indeed.

Suppose my birthday is today and I was born 23-09-1951

Suppose my birthday was not today but 6days after tomorrow...
Your function would say that I am 55 years old wrong
...
Suppose my birthday was not today but 10days after tomorrow...
Your function would say that I am 55 years old wrong
...
For how many days your function will be wrong ???
Too many !!

This is a repeating issue EACH year !!

yes, and the number of days per year where the expression is wrong is
equal to the number of leap years in the interval between birthday and
now().

Interestingly, changing the divisor to 365.25 reduces the error to a
single day in two years of four. (2 years of error, two years no error,
recurring)

Arno R

[Arno R]

"rq******@sympatico.ca" <bo*********@gmail.comschreef in bericht news:11**********************@m73g2000cwd.googlegr oups.com...

Interestingly, changing the divisor to 365.25 reduces the error to a
single day in two years of four. (2 years of error, two years no error,
recurring)

Hi Bob,

Yes, this math is *much* better, but still wrong ...
Since we can use a function that we can rely on, we don't need to use an expression that is not reliable.

Arno R

[rquintal]

Arno R wrote:

"rq******@sympatico.ca" <bo*********@gmail.comschreef in bericht news:11**********************@m73g2000cwd.googlegr oups.com...

Interestingly, changing the divisor to 365.25 reduces the error to a
single day in two years of four. (2 years of error, two years no error,
recurring)

Hi Bob,

Yes, this math is *much* better, but still wrong ...
Since we can use a function that we can rely on, we don't need to use an expression that is not reliable.

Arno R

I'm in complete agreement.