Nick,

I get 1.7 using your formula and dates.

Renoir

>I am having problem with the following formula
>ROUND(((DATE()-(DATE()-Payroll_tbl.edate))-Employee.e_cntysnrdte)/365.25,1)
>
>
>where my Payroll_tbl.edate = 11/30/01 and my Employee.e_cntysnrdte = 03/11/00
>I get the result of 101.7 instead of 1.7
>
>
>
>Thanks
>Nick Patel