since the beginning of last month

[ISS]

What's the proper query syntax that will retrieve for me all records created since the beginning of last month?

 

[tlbroadbent]

Select *
From tbl
Where CreateDate>=DateSerial(Year(Date()),Month(Date())-1,1) Terry

http://members.home.net/tlbroadbent/prog.htm

_____________________________________
Man's mind stretched to a new idea never goes back to its original dimensions. - Oliver Wendell Holmes

 

[ISS]

Thanks. I knew it was something to do with serial, but I never quite got the wording right.