AnsweredAssumed Answered

Age in Years

Question asked by Annette on Feb 6, 2015
Latest reply on Feb 10, 2015 by philmodjunk

Title

Age in Years

Post

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.

Thanks!!!

Outcomes