The format, needs to expand to a specific date in order to be able to execute a range query.
if you need to filter by specific days of the month, the best strategy would be to extract that day into it's own field day_of_month, which as a short, and then do a simple range query against that.
--Alex