Under the setup > sales > sales rules you can specify postcodes as ranges between two values (high and low) per search line.
I’d like to do this with a saved contact search as well (to use as part of a contact group for an email campaign) but when using postal code as the column type on a search line, I can only choose from “any, is, is empty, starts with, contains, is not, is not empty, does not start with, does not contain.”
Is there any way of using a formula field to do a range search for post codes?
eg: line1 might be searching for postcodes between 4054 to 4068 and line2 might be looking for 4868 to 4888.
I’d prefer to avoid having to put in 20+ lines with an individual “is” match for a single postcode per line if possible.
Thanks in advance for any help.
This is a cached copy. Click here to see the original post.