1 Reply Latest reply: May 15, 2014 9:56 AM by Nick Osdale-Popa RSS

    Fillter Help

    Cwroblewski _

      I'm new to Monarch and would like to apply a filter to a field.

       

      I would like to write the following expression.

       

      Range is between 500000 and 599999, but does not include 540000 to 540200, and 560100 to 560300.

       

      Thanks in advance.  If anyone can direct me to sample filters (expressions) as well that would be great.

        • Fillter Help
          Nick Osdale-Popa

          You could try something like this:

           

          (replace MyField with the appropriate field from your model)

           

          [font="courier"]( >= 500000  .And. < 540000)  .OR.  

          ( > 540200  .And. < 560100) .OR.

          ( > 560300  .And. <= 599999) /font[/quote]