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.
You could try something like this:
(replace MyField with the appropriate field from your model)
( > 560300 .And. <= 599999) /font[/quote]