Ok your other option is find the first and the last date of each month and use less than or greater to retrieve the values. You probably need some IF or Switch condition to determine which month and set the range of values in a variable or something. Finally use those values in your query.
Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up