Show only records entered within last month? (1 Viewer)

N

NewShoes

Registered User.

Local time

Today, 07:47

Joined

Aug 1, 2009

Messages

223

• Jul 23, 2011

• #1

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

Wino Moderator

Staff member

Local time

Today, 07:47

Joined

Aug 30, 2003

Messages

36,124

• Jul 23, 2011

• #2

At its simplest, a criteria of:

Between Date() - 30 And Date()

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

 

N

NewShoes

Registered User.

Local time

Today, 07:47

Joined

Aug 1, 2009

Messages

223

• Jul 24, 2011

• #3

Thanks Paul!

 

pbaldy

Wino Moderator

Staff member

Local time

Today, 07:47

Joined

Aug 30, 2003

Messages

36,124

• Jul 25, 2011

• #4

No problem!