Hi,
In order to retreive all the records with created datetime in last month here is the SQL I use,
Select * from table a where
a.created_dt >= Convert(datetime, convert(char, month(getdate()-day(getdate())))+'/01/'+
convert(char,year(getdate()-day(getdate()))))
and a.created_dt <...