AnsweredAssumed Answered

Age Calculation in two fields

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

Title

Age Calculation in two fields

Post

Hello 

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.

Outcomes