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

Not really mathematically correct but an easy way would be to just remove the decimals, i.e. with a regular expression... ;-)