Current month sepcific day query

[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

 

[dan artuso]

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