Calculating Age

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Julie Nicole (julie.holmes_at_quicksilver.net.nz)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 18:56:58 +1200

If I have the Date of Birth in a field, what expresion can I use in another
field, say AGE field, that would calculate the actual age automatically?

Like DOB field has 29/06/66 in it so Age field becomes 38 calculated
automatically when DOB is entered.

thanks
Julie

Relevant Pages

  • DateDiff Error
    ... each with a DOB field and an Age field. ... using the following expression to display the age in each form: ... thelp. ...
    (microsoft.public.access.forms)
  • trouble with a date field
    ... I have a field called DOB and it is a date field. ... Everyone's date of birth is in the field. ... I created an AGE field and used this calculation: ... The file is on a FMP Windows server and is being used with Windows FMP 11 by about six staff members. ...
    (comp.databases.filemaker)
  • caculating age
    ... be able to imput the persons date of birth into one field ... the age field. ... Any assistance would be appreciated. ...
    (microsoft.public.word.tables)
  • Change event trigger
    ... change the Date of Birth field of the current record of form B. I ... I want to trap this change event so that in form B, ... programmatically calculate the Age field based on the Date of Birth ... Tony ...
    (comp.databases.ms-access)