Calculate AGE

[Guest]

i need help to calculate age by using dob.what kind of field do i need for
the dob and what kind of format?

thanks irit

 

[Douglas J. Steele]

DOB should be a date field.

Age (in years) is calculated as

DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)

DateDiff calculates how many "year crossings" occur between the two dates:
it'll say that there's 1 year between 31 Dec of one year and 1 Jan of the
next year, despite the fact that it's really only 1 day. That's why you
subtract 1 from the calculation if the birthday hasn't taken place yet this
year.

If you want finer granularity than years, (say 28 year, 7 months and 2
days), see http://www.accessmvp.com/DJSteele/Diff2Dates.html

 

[Guest]

check out

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

 

[Guest]

I used itlike this but it is not working,I change the format in the ageyearly
to a date formal(mm/dd/yyyy)
AgeYearly = DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)
still it is not working
thanks Irit

DOB should be a date field.

Age (in years) is calculated as

DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)

DateDiff calculates how many "year crossings" occur between the two dates:
it'll say that there's 1 year between 31 Dec of one year and 1 Jan of the
next year, despite the fact that it's really only 1 day. That's why you
subtract 1 from the calculation if the birthday hasn't taken place yet this
year.

If you want finer granularity than years, (say 28 year, 7 months and 2
days), see http://www.accessmvp.com/DJSteele/Diff2Dates.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

i need help to calculate age by using dob.what kind of field do i need for
the dob and what kind of format?

thanks irit

 

[Guest]

Thank you very much it's solve my problem
irit

check out

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

 

[Douglas J. Steele]

What didn't work about it?

I noticed in another response that you said
http://www.mvps.org/access/datetime/date0001.htm worked for you. What I gave
you is essentially the same as the first response on that page.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

I used itlike this but it is not working,I change the format in the
ageyearly
to a date formal(mm/dd/yyyy)
AgeYearly = DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)
still it is not working
thanks Irit

DOB should be a date field.

Age (in years) is calculated as

DateDiff("yyyy", [DOB], Date) - _
IIf(Format([DOB], "mmdd") < Format(Date, "mmdd"), 1, 0)

DateDiff calculates how many "year crossings" occur between the two
dates:
it'll say that there's 1 year between 31 Dec of one year and 1 Jan of the
next year, despite the fact that it's really only 1 day. That's why you
subtract 1 from the calculation if the birthday hasn't taken place yet
this
year.

If you want finer granularity than years, (say 28 year, 7 months and 2
days), see http://www.accessmvp.com/DJSteele/Diff2Dates.html

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

i need help to calculate age by using dob.what kind of field do i need
for
the dob and what kind of format?

thanks irit