Age in reports

[Dave]

Hi

Hope you can help with this one. I need a report to show peoples ages based
on their birthday. I have 4 fields on the report. Ths first is simply
their name. The second is their date of birth. The third needs to show how
many days old they are and the final one how old they are in years. For the
third field I am using the formula =(now())-[dob]. Can i get it so it only
show days and ignores the time element of it? For the final colum all I
want to do is to divide the value from the third column over 365 (im
ignoring leapyears for now), how can i do this so that it shows only the
full completed years and does not display the decimals after the integar?

Thanks

 

[Allen Browne]

Use Date() instead of now, i.e.:
=Date() - [dob]
Alternatively:
=DateDiff("d", [dob], Date())

You can get an approximation of the age as:
=Int((Date() - [dob]) / 365.25)

For the exact age in years, see:
http://allenbrowne.com/func-08.html
or for the age in years, months, and days, see:
http://www.accessmvp.com/djsteele/Diff2Dates.html

 

[Dave]

Thanks

Use Date() instead of now, i.e.:
=Date() - [dob]
Alternatively:
=DateDiff("d", [dob], Date())

You can get an approximation of the age as:
=Int((Date() - [dob]) / 365.25)

For the exact age in years, see:
http://allenbrowne.com/func-08.html
or for the age in years, months, and days, see:
http://www.accessmvp.com/djsteele/Diff2Dates.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Hi

Hope you can help with this one. I need a report to show peoples ages
based on their birthday. I have 4 fields on the report. Ths first is
simply their name. The second is their date of birth. The third needs
to show how many days old they are and the final one how old they are in
years. For the third field I am using the formula =(now())-[dob]. Can i
get it so it only show days and ignores the time element of it? For the
final colum all I want to do is to divide the value from the third column
over 365 (im ignoring leapyears for now), how can i do this so that it
shows only the full completed years and does not display the decimals
after the integar?

Thanks

 

[AlCamp]

Dave,
Check out the DateDiff function...
[ThirdField] = DateDiff("d",Date(),DOB)
[FourthField] = Int([ThirdField] / 365)
hth
Al Camp

 

[Hermie]

Allen
You can put a function for calculating the age see:
http://support.microsoft.com/default.aspx?scid=kb;en-us;100136

herman