Current Month -1 in DTS SQL Query Designer

[sgp_imported]

I would like to filter data to get the "last full month" only. How can this be done in DTS?

Thanks!

 

[MaffewW]

pls can you provide a bit more info. if its just a sql statement you are after to get all records from the previous month (this will give you all June 2003 records) try this

select *
from tablename where datepart(mm,datetimefield)+ datepart(yy,datetimefield)= datepart(mm,getdate()-1) + datepart(yy,getdate())

Matt

Brighton, UK