query criteria of date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a date field in my query and i want to put into the criteria to select
all the records that the date in the date field is in todays month - ie the
current month
 
Try this in the Criteria row under your date/time field:

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

That returns records for the current month of this year.
If you wanted "of any year", post a reply.
 
Another Guy responded to my question but i'm not sure where his post is he
told me to type in

Criteria: Between DateSerial(Year(Date()),Month(Date()),1) AND
DateSerial(Year(Date()),Month(Date())+1,-0)

and it worked. Thanks a lot!!
 
Back
Top