[EpiData-list] Calculating age

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Tue Nov 24 01:22:29 CST 2009

Hello, I have a little problam calculating intervals like age from 
two dates using formula 


         LET AGE=ROUND(INT(TODAY-DOB)/365.25)

It returns the value rounded to the nearest whole number, which is a
problem in records of people with birthday 6 and more months (183 
days and more) from today's date, as it makes them one year older.. 
Is there any way to get result rounded towards zero? 


Kind regards


More information about the EpiData-list mailing list