hi,
i print
? inyearofbill&&i get 2020
********************************
thisform.text3.Value=year(date())
inyearofbill=2000+VAL(LEFT(ALLTRIM(STR(thisform.text3.Value)),2))
? inyearofbill
i get 2020,but thisform.tet3.value=2005

i get another message&&Operator/operand type mismatch
SELECT * from billinfo WHERE billno=thisform.text4.value and YEAR(billinfo.billdate)= inyearofbill INTO CURSOR curbilldata

thanks.

>Is the value of thisform.text3.Value already bound to a numeric field?
>
>inyearofbill=2000+VAL(LEFT(thisform.text3.Value,2))
>
>try this
>
>inyearofbill=2000+VAL(LEFT(ALLTRIM(STR(thisform.text3.Value)),2))