Show only records entered within last month?

[NewShoes]

Hey all,

I'm sure this is pretty simple but I cant think of the answer! I have a subform that displays records that have been entered. What I would like to do is only display records a month previous to today's date.

So, if today's date is 30th Sep 2011, I would like to display all records that were entered from 1st Sep 2011 (or 31st Aug 2011, whatever works!).

Thanks,
-NS

 

[pbaldy]

At its simplest, a criteria of:

Between Date() - 30 And Date()

You could use the DateAdd() function to get an exact month.

 

[NewShoes]

Thanks Paul!

 

[pbaldy]

No problem!