Date Filter

redStripe

Hello,
I try to filter on a date via

SETFILTER(MyDate, '%1.. | blank', TODAY);

... in other word i try to get all records with a date in the future
or a blank datefield.
can anybody help me how to do that?

thanks.

redStripe

awarn

Try:

SETFILTER(MyDate, '%1.. |0D', TODAY);

-a

redStripe

it doesn't work
navision says that 0D is not valid date.

Alex_Chow

Do this instead:

SETFILTER(MyDate,'%1..|%2',TODAY,0D);

redStripe

YEAAAA Man ..it works :-)

Thanks.