If you are doing the query on the first day after the month for which you want the data

Select * from mytable ;
into mynewtable ;
where month(daterequired) = month(date()-1) ;
and year(daterequired) = year(date()-1)

Hernan


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