The other day I needed to create a query where it returns all records with dates for the current month. I did not want to hard code the beginning and ending dates in the query, so I came up with the following line of code you can paste into your query:
Between CDate(Month(Date()) & «/1/» & Year(Date())) And DateAdd(«m»,1,CDate(Month(Date()) & «/1/» & Year(Date())))-1
The criteria line above uses the «Between And» operators to calculate the first of the month and the end of the month of the current date. Enjoy!