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