Age Nearest

[Guest_imported]

Hi,

I need a field that calculates age nearest from birthdate. Currenlty I am able to calculate age from birthdate but I am unable to get age nearest (i.e. a person who is 39 years and 8 months old will show up on my report as 40).

Thanks.

 

[MichaelRed]

? Round(DateDiff("m", #8/21/42#, Now()) / 12, 0)
59
? Round(DateDiff("m", #1/21/42#, Now()) / 12, 0)
60

MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over

 

[Launcher6]

I have somewhat the same problem and am currently using a label as a reference to get the age. I have the field DOB(Date of Birth) and then have a label with the function =Now()-[DOB] as the control source. Once I get the age I input it into the a AGE field.

I could like to get it to automatically input it in the AGE field but because of the funtion I cannot get it to put it as a number.