This tip covers the instruction model: AGE(DATE). Use this expression if you want to know the age in terms of years as of the current date. If you want to know the age as of a specific date, other than today, then you will need to use YEARS FROM( DATE , DATE )
What are the elements?
- AGE: The function
- DATE: The start date for measuring the age. It can be a birth date or the date a debt was incurred.
How do you use it?
AGE(CLIENT Date of Birth DA)