I am filtering a table by a date, this is the code:

with thisformset.mainform.infoframe.stageentries
if .groupdate.option2.value = 1 then
set filter to project_id = thisformset.mainform.projnum.value and ;
ccustno = thisformset.mainform.compnum.value and ;
date >= ctod(.startdate.value) and ;
date <= ctod(.enddate.value)
else
set filter to project_id = thisformset.mainform.projnum.value and;
ccustno = thisformset.mainform.compnum.value
endif
endwith

If the second filter runs, the output is fine, but if the first filter runs, then the output is blank. If I replace the .startdate.value and .enddate.value with actually date strings, ie. '05/05/1999', then the output is fine. I've tried using alltrim and I've tried using the .text field, both don't help. If anyone has any ideas, they would be appericated. It driving me crazy!

thanks