I have a database where I need to calculate the members age (in years and months) as of a specific date (6/1/2018 )
I am using BDATE and SDATE as my fieldnames
Example - MEMBER with BDATE of 7/1/2010 would return a value of 8.1
MEMBER with BDATE OF 5/1/2010 would return a value of 7.11
Thanks in advance for your help.
I am using BDATE and SDATE as my fieldnames
Example - MEMBER with BDATE of 7/1/2010 would return a value of 8.1
MEMBER with BDATE OF 5/1/2010 would return a value of 7.11
Thanks in advance for your help.