How can i match a value in my query with a parameter that has range e.g:

i want to check where order_date between {?Datapara}
where date parameter is a single field that has range.