Hello all,

How to select last month data from mytable.dbf ?

mytable.dbf

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:

Select * from mytable into mynewtable where month(daterequired) =
subs(daterequired,5,2).

TIA