Ladies and Gents,
I have a query that calculates age by subtracting Date of Birth from Date(). The result appears in days and I divide this by 365.25 to calc years (accounting for leap year with the .25). This number needs to appear sans decimals, but it gets rounded up once the person hits over their half-year mark. Is there a way to use the Round function to round these numbers down and truly show how old an individual is by years? Thanks in advance.
UZ
I have a query that calculates age by subtracting Date of Birth from Date(). The result appears in days and I divide this by 365.25 to calc years (accounting for leap year with the .25). This number needs to appear sans decimals, but it gets rounded up once the person hits over their half-year mark. Is there a way to use the Round function to round these numbers down and truly show how old an individual is by years? Thanks in advance.
UZ