How does Between and Not Between filter type works?

Between filter type

The Between filter checks if a value falls within a specific range, including the start and end points (depending on the platform — most include both).

It’s like asking: “Is this value between X and Y?”

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.

It’s like asking: “Is this value outside the range X to 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 ❌

Available for field types: Number, Decimal, Date

To know more on how to use these filter types, you can watch this video.

To know more about the other filter types you can use, see this article - Filter types in DESelect Segment.