Filter operators
Every operator by field type, and every relative date expression.
By field type
Section titled “By field type”| Field type | Operators |
|---|---|
| Text, email, phone, URL, text area | Equals, Does Not Equal, Is Empty, Starts With, Ends With, Contains, Does Not Contain |
| Picklist | Same as text |
| Multi-select picklist | Equals, Does Not Equal, Is Empty, Includes, Excludes |
| Number, currency | Equals, Does Not Equal, Is Empty, Greater Than, Less Than, Less Than or Equal, Greater Than or Equal, Between |
| Percent | Same as number, without Between |
| Date, date/time | Same as number, including Between |
| Time | Same as number, without Between |
| Checkbox | Equals, Does Not Equal |
| Lookup, ID, formula | Equals, Does Not Equal, Is Empty |
| Location | Is Within, Is Not Within. See Filter by distance from a location. |
Values
Section titled “Values”| Operator or field | Value |
|---|---|
| Is Empty | True matches empty fields, False matches filled ones. It checks for no value at all, not for a space. |
| Checkbox | True or False. |
| Between | From and To, both included. To must be larger than From. On a date/time field, only the date counts. |
| Picklist, lookup | Several values: Equals matches any of them, Does Not Equal none of them. Each value shows as a pill. |
| Multi-select picklist | Includes and Excludes check single selected values; Equals and Does Not Equal compare the whole selection. |
| Text | A list of values with Equals, Does Not Equal, Contains, Does Not Contain, Starts With, Ends With. See Match a list of text values. |
| Date, date/time | A calendar date or a relative date. See Relative dates. |
Relative dates
Section titled “Relative dates”Under a date value, select Use relative date. CAB accepts the relative date expressions of Salesforce, in upper or lower case:
| Pattern | Examples |
|---|---|
| One day | YESTERDAY, TODAY, TOMORROW |
| A period | LAST WEEK, THIS MONTH, NEXT QUARTER, THIS FISCAL YEAR |
| The last or next n periods | LAST 30 DAYS, NEXT 2 WEEKS, LAST 4 FISCAL QUARTERS |
| n periods ago | 90 DAYS AGO, 2 FISCAL YEARS AGO |
FISCAL follows the fiscal year in Salesforce Setup under Fiscal Year and works with quarters and years only. Between takes calendar dates only. For the full list, see Relative date values in the Salesforce Help.
Operators that can slow large audiences
Section titled “Operators that can slow large audiences”Contains, Does Not Contain, Ends With, Does Not Equal, Excludes and Is Empty with False count as possibly non-selective: on very large objects, such a condition can make a run slow. CAB flags them in the diagnostics. See Diagnose an audience query.

