Age in Years
Hi all, appreciate any help very frustrated at this point as nothing is working.
I'm trying to get an age of a person as of a given date.
I have a global field where I put a date in and this is saved in a variable ... $$EndDate
I would like to find out the age of a person from their DOB to $$EndDate. All the ways I try at this point have given me crazy numbers or negative numbers.
So....if someones birthday was 06/02/10 and $$EndDate is 06/02/15 then result would be 5
If DOB was 01/03/10 and $$EndDate is 06/02/15 then result would be 4.