How to Round Down

I have an expression to calculate a person's age based on today minus the birthday:

Number(HOUR(TODAY()-[DOB])/365.25/24)&" yr"



I am finding expressions for rounding up, but how do I get it to always round down until the birthday has actually passed? I had an entry today that shows the person to be 75 years old, but they are still 74 for another week.

Thanks


Solved Solved
0 4 502
1 ACCEPTED SOLUTION

You must have had problems elsewhere.

Capture dโ€™eฬcran 2022-04-05 aฬ€ 00.51.39.pngCapture dโ€™eฬcran 2022-04-05 aฬ€ 00.52.41.pngCapture dโ€™eฬcran 2022-04-05 aฬ€ 00.55.43.png

View solution in original post

4 REPLIES 4
Top Labels in this Space