Age Calculation
I have a Date of Report field, a Date of Birth field and next to it we compute Age; how can I fill the Age field automatically based on DOB and the original date of the report?
Forum Discussion
this was posted about a year ago by another user (ddixonr). It looks right to me.
I'm assuming here that your field for date of report is called [DOR]
The field type would be formula-numeric
Year([DOR])-Year([DOB])-1
+
If(Month([DOR])>Month([DOB]),1,0)
+
If(Month([DOR])=Month([DOB]) and Day([DOR])>=Day([DOB]),1,0)
I'm assuming here that your field for date of report is called [DOR]
The field type would be formula-numeric
Year([DOR])-Year([DOB])-1
+
If(Month([DOR])>Month([DOB]),1,0)
+
If(Month([DOR])=Month([DOB]) and Day([DOR])>=Day([DOB]),1,0)