Criteria for Current Month

[doulostheou]

Someone had posted a link to the following article:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q88657

In it, it gives an expression to represent the current month. One of my form has the current month as its criteria. When I first setup the database I manually typed this into the query and changed it every month. This is obviously ineffective, so I used the expression given in the article. Unfortunately, the expression gives me a different result than typing it out.

DateSerial(Year(Date()), Month(Date()), 1) is the expression given in the article. It pulls 108 records.

Between #5/1/02# And #5/31/02# is what I've been doing. It returns 839 records.

Does anyone know why I am getting the discrepency and/or does anyone know how to properly set my criteria to the current month?

 

[DALeffler]

Try this as your criteria statement in your query:

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

Check your 'puter's sys date!

Doug

 

[doulostheou]

Thanks. Worked like a charm.