>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
Nick,
That formula essentially same as :
ROUND((Payroll_tbl.edate-Employee.e_cntysnrdte)/365.25,1)
And I think problem comes from the fact that e_cntysnrdte value 03/11/00 is 03/11/1900.
Cetin