Filter <> 0..9

roshini
roshini Member Posts: 122
edited 2009-01-08 in NAV/Navision Classic Client
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

Comments

  • kapamarou
    kapamarou Member Posts: 1,152
    Have you tried:
    SETFILTER(Customer."No. of Due Months",'<%1|>%2',0,9);
  • roshini
    roshini Member Posts: 122
    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
    kapamarou Member Posts: 1,152
    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
    roshini Member Posts: 122
    First Record having value 1 in field "No. of Due Months". that record also displaying.

    Thanking You
  • kapamarou
    kapamarou Member Posts: 1,152
    You're welcome.

Categories