I have a form where I enter client data
When I enter the date we review the material for the client and the client's date of birth I have the age automatically enter in the age column
=DateDiff("yyyy",[dob],[reviewdate])
Is there a way to also have the client's age automatically enter as of today's date
Basically, I need the age at the time we review and the age today
When I enter the date we review the material for the client and the client's date of birth I have the age automatically enter in the age column
=DateDiff("yyyy",[dob],[reviewdate])
Is there a way to also have the client's age automatically enter as of today's date
Basically, I need the age at the time we review and the age today