AnsweredAssumed Answered

calculating actual age this year.

Question asked by kkalach on Apr 4, 2016
Latest reply on Apr 6, 2016 by kkalach

I want actual age this year not actual age.  Any suggestions?

 

 

Let([

now = Get( CurrentDate ) ;

presentyear = Year( now ) ;

birthyear = Year( birthdate ) ;

birthday_thisyear = Date( Month( birthdate ) ; Day( birthdate ) ; Year(now) )

];

 

presentyear - birthyear -

 

// reduce result by 1 if birthday didn't take place this year

If( now < birthday_thisyear ; 1 )

)

Outcomes