current month criteria?

Question

Hello,

In access what criteria can put in to a query so that only records from the current month are displayed?

Thanks

Answer 1

Use the DatePart() function to get the current month from todays date, then put /1/ and the datepart to get the current year. The use the DatePart to get the CurrentMonth again, ADD ONE TO THE CURRENT MONTH, and set the date to the first of the month FOR NEXT MONTH. Then Subtract one from the DATE OF THE MONTH for the first of next month. Then it won't matter if the month has 28, 29, 30 or 31 days in total.