Filter Query by Date Range

[mrssevans]

I have a query that I am trying to filter by date range using a form that I have created. It almost works, but I think I have a format issue and it is returning incorrect ranges. Okay, in my query the date is formatted as "m/yyyy" from the normal "mm/dd/yyyy", which is done in the query and the unbound field on the filter form is formatted at "m/yyyy". Even if I try using the normal format of mm/dd/yyyy on the filter form and in the query it doesn't seem to return the correct range. I have used this a million times in other queries, but I am stumped on this one. Can anyone steer me in the right direction?

 

[mrssevans]

That is sort of what I had to do to get it to work. I had to unformat the filter form and just use the "m/dd/yyyy" format in order for it to even format at all. I will try what you suggested and see if that works. It might be a better solution to this issue. Thank you so much for the response.