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.