Hi I'm trying to calculate age in years from a date of birth date field.
I've seen the old connect post
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.