John

set filter to between(DATE1,{^1999-01-01},{^1999-12-31})
or
set filter to date1 >= {^1999-01-01} and date1 <= {^1999-12-31}


>Can anyone offer me any help on how to filter between a low date, high date. I've tried several things already and i just can't seem to grasp the idea.
>
>***Here is an example of what i have already
>
>SELECT FOWLER
>*SET ORDER TO 4
>
>LRESULT=BETWEEN (DATE1,01/01/99,12/31/99)
>
>SET FILTER TO DATE1=LRESULT
>thisform.Refresh()
>
>Any help would be greatly appreciated.
>
>Thanks John Faulkner