>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
I am actually using this formula in a query like the following to generate a report:

SELECT Payroll_tbl.pp, Employee.e_fname, Employee.e_lname, Employee.e_mi,;
  Employee.e_dob,;
  ROUND(((DATE()-(DATE()-Payroll_tbl.edate))-Employee.e_dob)/365.25,1),;
  Employee.e_cntysnrdte,;
  ROUND(((DATE()-(DATE()-Payroll_tbl.edate))-Employee.e_cntysnrdte)/365.25,1),;
  ROUND(Payroll_tbl.slbal*Payroll_tbl.rate,2),;
  ROUND(Payroll_tbl.vacbal*Payroll_tbl.rate,2),;
  ROUND(Payroll_tbl.slbal*Payroll_tbl.rate,2)+ROUND(Payroll_tbl.vacbal*Payroll_tbl.rate,2);
 FROM  employee!employee INNER JOIN payroll!payroll_tbl ;
   ON  Employee.e_ssn = Payroll_tbl.ssn;
 WHERE Employee.e_empstatus = 4;
   AND Employee.e_dob <> {  /  /  };
   AND Payroll_tbl.pp == ?lc_pp;
 HAVING Employee.e_ssn=Payroll_tbl.ssn=.T.;
 ORDER BY 8 DESC, Employee.e_dob DESC

The problem is sometimes I get 107.1 result and other times I get 1.7 result. As for SET CENTURY, it is set to ON. I checked using disp status. Baffling isn't it?

Thanks
Nick Patel