I have two fields in a table <DOB> and <Age>
I'd like to update the Age after someone adds the user's DOB.
I've got this to work in a View but then I end up needing an extra table to see the calculation.
This is my code as an expression in the View.
DateDiff(MONTH, DOB, GetDate()) / 12 - Case When Month(DOB) = Month(GetDate()) And Day(DOB) > Day(GetDate()) Then 1 Else 0 End
How do I add this to the Table to update after saving.
Thanks