I have a birtdate column in date format in my table named tblJJDP. I need to create a computed column (AgeReg) that automatically calculates the birthdate and the Date of Registration (DOR) column.
So if the person was born on 1/1/00 and they were registered on 1/1/12, then the AgeReg column should show 12 years old.
Column names are
DOR - date type
Birthdate -date type
AgeReg - integer type