>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
John,
Directly put your expression as part of filter command. ie:
set filter to between(date1, {^1999/01/01}, {^1999/12/31})
Or if it really must be a variable then make sure variable is scoped enough. ie:
set filter to ;
between(date1, thisform.StartDate.Value, thisform.EndDate.Value)
Cetin