Round a number

I need to calculate people’s age and it’s very important to me if they had or not their birthday (important if they have a certain age or not). When I use Today - Date of Birth, it rounds up to the next integer, how could I truncate the number to show me the integer part of that number obtained.
Ex: after calculation, someone has 14.68 years old. They have 14 years old, didn t celebrate 15th anniversary yet. I want the field to show 14.

Hi,

You may test to see if ROUNDDOWN() works for your case:

1 Like