don't use CTOD() and put {/} in the Value property of the date textboxes to make them date type.
>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
- Jayesh