Criteria issue. Want to use a date

bowes884

Registered User.
Local time
Today, 18:14
Joined
May 25, 2005
Messages
33
Hey. Instead of going back every month and changing the date to the first. Is there a function I can put in the Criteria that will automatically filter for stuff only since the begining of the month. Right now I am using this:>=#5/1/2005#. I just want to to automatically change when a new month occurs.

Bowes
 
Code:
>=DateSerial(Year(Date()), Month(Date()), 1)
 
Awesome thanks.

Bowes
 

Users who are viewing this thread

Back
Top Bottom