Create a built-in age function
Create a built in age function. This function should take in birthdate and ageasof_date as inputs, and calculate age as an output.
Datediff is close, but a little bit off, and requires adding a more complex if/then corrective function to get age fully precise.
In cases of contractual or regulatory compliance, the added precision is required.