Membership Expired

[Paul]

I want a query which will display those dates that
expired last month and beyond.

The query shows the members ID, name and surname and
expiry date.

< Date() - only shows the expiry dates before present

What I do want is to display those dates that expired
last month and before that - in a real life example -
December and further ie '< todays month'

I tried < month(date()) - never worked

Thankx

Paul

 

[John Slattery]

You might consider this:

< DateSerial(Year(Now()), Month(Now()), 1)

You could substitute Date() for Now(), if you like.

 

[John Smith]

< CVDate("1/" & Format$(Now, "mmm/yyyy"))

should be what you want