Date query problem

[Toolpusher]

Hi

I run a query on a set of data and just use >Date()-30 to give me that data over the last 30 days and thats fine, Now I want to run similar query say today 16th March that only gives me the data exactly for February or run the query in June sometime that only gives me that data for May. Dont think I am making my self clear I want the query to only look at the data for the previous month ignoring any part of this month.

 

[pbaldy]

Try

Between DateSerial(Year(Date()), Month(Date()) - 1, 1) And DateSerial(Year(Date()), Month(Date()), 0)

 

[Toolpusher]

How the heck do you guys do this been trying to get this on and off for weeks.

Thank you very much

 

[pbaldy]

It's magic, but don't look behind that curtain over there.

Happy to help!