AnsweredAssumed Answered

How do I round down for age date calculation?

Question asked by gadams on Oct 29, 2014
Latest reply on Jul 20, 2015 by chris.ben

Hi I'm trying to calculate age in years from a date of birth date field.

 

I've seen the old connect post

Nintex Connect - Need to calculate age of patient based off of birthdate

Which uses dateDiffDays(DOB,Current Date)/365

 

The problem is that this gives a decimal number and not an integer.

If I use the round function it will also round up in some cases

eg 7.78 would be come 8 when in fact they are still 7 years old.

 

Any ideas on how to solve this?

 

I did some playing around in Excel that has some other functions such as YEARFRAC and ROUNDDOWN which produce a more accurate result.

However feeling a bit limited with the runtime functions available.

 

Thanks

Outcomes