>>A simple demo filter expression could be:
>>
>>set filter to order_date = date()
>
>
>how?
>Do you mean with the set date to setting ? or something else?
>
>I only use to a skip not skip -1 ; that takes hell of a time. with set filter.
>
>any peices of code ?
>
>suhashegde

Suhas,
It is clear.

use orders
set filter to order_date = date() && but of course in sample data all dates are in far past to hide the weirdness

Maybe this one would be more understandable:
create cursor myCursor (f1 t)
for ix = 1 to 1000
insert into mycursor values (rand()+datetime())
endfor

set filter to f1 < datetime()
browse

Cetin