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.