Auto update field on save

crash · Post by **crash** » Thu Mar 24, 2022 5:03 am

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

MichaelG · Post by **MichaelG** » Thu Mar 24, 2022 7:03 am

You should simply create the Age field that is calculated based on the Date of Birth in your database view. Please google for "Calculate age from date of birth in SQL" for examples.

crash · Post by **crash** » Thu Mar 24, 2022 9:08 am

Thanks but where do I put my code. I want the age to auto update. I did try add this as an expression in my field in the primary table but it does not auto update.

Or do you mean it must be done in my sql code in my databaseâ€¦

MichaelG · Post by **MichaelG** » Fri Mar 25, 2022 6:52 am

do you mean it must be done in my sql code in my database

Yes, it is the better way.