Sorry, thought I tested that well enough. Review the following:
Code:
?DateAdd("yyyy",1,Dateserial(Year(date),month(date),01))
result: 1/01/21
Code:
?dateadd("m",1,DateAdd("yyyy",1,Dateserial(Year(date),month(date),01)))-1
result: 1/31/21
so
Code:
Between DateAdd("yyyy",1,Dateserial(Year(date),month(date),01)) AND dateadd("m",1,DateAdd("yyyy",1,Dateserial(Year(date),month(date),01)))-1
Starting to look messy. If you were doing this in code or via a form it would look simpler. As a query, yes, you'd have to put that as criteria. You could also call a function from the query via a calculated field, such as MyDate: NameOfTheFunction(nameOfYourDateField)