could also be that your filter is being set against the variable reference and not the value. try this:
lcFilterCondition = "mytable.myfield = myvalue AND " + ;
"BETWEEN(mytable.mydatefield,{" + ;
"myform.mytextdate1 + "},{" + ;
"myform.mytextdate2 + "})"
SET FILT TO &lcFilterCondition
HTH
I try to stay online, to get better information.
I try to get away from the office once in a while..
But they KEEP... PULLING.. ME.. BACK.. IN!!!