i use SET FILTER TO BETWEEN(date,from,to) to filter records whose time fall between from and to.

now, i have a table with datefrom and dateto fields. i have in my form two textfields that accepts from and to.

how do i use BETWEEN to filter my records given the from and to inputted by my users to select all records in my table that is between datefrom and dateto fields?