Filter <> 0..9

roshini

Hi Nav Experts,

I am using SETFILTER function

SETFILTER(Customer."No. of Due Months","%1..%2",0,9);
working fine. I want to use <> for the above SETFILTER.

How can I use <> for the above code ??
ex: <> 0..9


Thanking You

kapamarou

Have you tried:
SETFILTER(Customer."No. of Due Months",'<%1|>%2',0,9);

roshini

Thanks a lot Mr. Kapamarou, for your quick reply.

but only problem with first record. It is not filtering first record.

How to handle ??

Thanking You

kapamarou

What is the value for the first record?

Maybe you need an equal sign...

SETFILTER(Customer."No. of Due Months",'<=%1|>=%2',0,9);

roshini

First Record having value 1 in field "No. of Due Months". that record also displaying.

Thanking You

kapamarou

You're welcome.