>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?
lcFilter = 'datefrom <= '+;
trans(dtoc(thisform.txtTo.Value,1),'@R {^9999/99/99')+'} and '+;
'dateTo >= '+;
trans(dtoc(thisform.txtFrom.Value,1),'@R {^9999/99/99')+'}'
set filter to &lcFilter
Cetin