Date and age

[Ken]

I am converting an access 97 database to access 2000.
A few error warnings came up during the conversion, but I got round them
with the exception of a text field.

The text field shows the age of someone.
It looks at the Date of Birth field [D-O-B] and compares it to today's date
then displays the result as an integer.
The formula in Access 97 is
=DateDiff("yyyy",[D-O-B],Date())-IIf(Date()<DateSerial(Year(Date()),Month([D
-O-B]),Day([D-O-B])),1,0)
This was given to me about 5 years ago from an access news group.

In access2000 the text box shows #Name?

Can anyone help with correct formula for 2000..
Regards
Ken

 

[Allen Browne]

Chances are that some of the code in your A2000 database requires a library
that is missing. From any code window, choose References on the Tools menu.
More info:
http://allenbrowne.com/ser-38.html

If that is not the problem, you can grab an Age() function from here:
http://allenbrowne.com/func-08.html