Month to date report??

[PQTIII]

What is the correct where statement in a query to show only the records that contain date in current month and year to date? I have In Month(Date()) , but that shows no records when I run the query.

Thanks pt

 

[lupins46]

to show records for the current month only you can use:

where [mydatefield]>=date()+1-day(date())