Previous Month expression (1 Viewer)

[AnnPhil]

How do you have a date field return the previous month data?

For example i have a date field and the criteris needs to be all days from the previous month. So if i was running this Jan 31, 2011, i need it to return me all records that have a date between Dec 1, 2010 and Dec 31, 2010.

Next month i run it on February 29, 2011 and i need it to return me all records that have a date between Jan 1, 2011 and Jan 31, 2011.

Thanks in advance for any help on this!

 

[boblarson]

It would be like this:

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

 

[AnnPhil]

Thanks, works great!