>Hi everyone,
>
>I'm at lost why this particular value in a text box "2017" doesn't match the fieldname (paystart) while the rest does like "2016", "2015" and the likes except "2017 as mentioned. I dont know what i might be missing out.
>
>here is the sample code
>
>

>
>** in a form there is a text box where one has to key in the year (.txtYear.value="2016")
>** A.paystart is a datefield in ORlist table
>
>local ldYear
>
>With Thisform
>     ldYear =  .txtYear.Value
>endwith
>
>SELECT A.paystart, A.clientID, B.ClientName, A.Amount FROM ORlist as A Left Join Client as B ON A.ClientID=B.ClientID;
>WHERE YEAR(A.paystart)=VAL(ldYear) INTO CURSOR CollectAmt ORDER BY A.clientid
>
>
>

>
>
>The results displays everything for any other year except "2017" and I have no idea why is it like this for this particular year 2017 and would always result into an operator/operand type mismatch error message.
>
>Any idea or tips on what i might be missing in this code?
>
>Thanks in advance
>
>Sonny

If you're using VFP9, I suggest to do

lnYear = cast(thisform.txtYear.value as int)

and use lnYear directly.

Also, do you have index on year(PayStart)? Otherwise your statement is not Rushmore optimizable.