Current month sepcific day query

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

Guest

Hello:

What would I place in a query for criteria to have it show the the current
month and a specific day of the month. Say the 1st or 15th day.

Thank you,

Robert
 
Hi,
I'm going to assume you have a field with a date in it (otherwise it would
be impossible)

The criteria would be something like this:

Where Month(yourDateField) = Month(Date()) And Day(yourDateField) = 15
 
Back
Top