Between and Not Between
These filter types are available for Number, Date, and Decimal field types.
Between filter type
The Between filter checks if a value falls within a specific range, including the start and end points (i.e. Is this value between X and Y?). Most platforms include both.
Example
You want to find customers who spent between 100 and 500 dollars.
- Field: Total Spend
- Filter: Between 100 and 500
Matches:
- Spend = 100 ✅
- Spend = 250 ✅
- Spend = 500 ✅
- Spend = 99 ❌
- Spend = 501 ❌
Not Between filter type
The Not Between filter checks if a value is outside a specific range, meaning it's less than the lower bound or greater than the upper bound (i.e. Is this value outside the range X and Y?).
Example
You want to find deliveries that happened not between April 1, 2025 and April 30, 2025.
- Field: Delivery Date
- Filter: Not Between April 1, 2025 and April 30, 2025.
Matches:
- Delivery Date = March 1, 2025 ✅
- Delivery Date = March 28, 2025 ✅
- Delivery Date = January 1, 2025 ✅
- Delivery Date = April 1, 2025 ❌
- Delivery Date = April 30, 2025 ❌