>daterequired idnumber lastname firstname > >2006/05/27 11111 bloe joe >2006/06/26 22222 hungry brian >2006/05/19 33333 keeper goalie >2006/04/18 44444 defence legs >>Suppose to have in mynewtable :
>2006/05/27 11111 bloe joe >2006/05/19 33333 keeper goalie >>I try this but not sure about syntax in SQL statments:
ldDate = DATE() SELECT * FROM mytable ; WHERE PADR(month(ldDate)-1,2,'0') = SUBSTR(mytable.daterequired,6,2) ; AND TRANS(YEAR(ldDate)) = LEFT(mytable.daterequired,4); INTO CURSOR/DBF mynewtable