AnsweredAssumed Answered

Age Calculation in two fields

Question asked by JoseHowardBustos on Feb 2, 2012
Latest reply on Feb 2, 2012 by philmodjunk


Age Calculation in two fields



I'm a physician trying to develop a database for a patient follow-up. I'm having a hard time trying to figure out the best way to calculate ages. Does anyone know how to write the 2 formulas for this?

I have 4 fields: 1. "First visit date" (this is entered manually) 2. "Date of Birth" 3. "current age" 4. "Age of first visit"

I want the "Current age (in years)" field to show the patient age based on the current date (system date) and that updates automatically.

and the other field: "Age of first visit" to show the age (in years) of the patient based on the field "First visit date"

Any help will be deeply appreciated.