between Function | Vantage CX - between - Vantage Customer Experience

Vantage Customer Experience User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Vantage Customer Experience
Release Number
1.6
Published
October 2023
Language
English (United States)
Last Update
2023-10-26
dita:mapPath
hbt1563223944614.ditamap
dita:ditavalPath
oyf1565965838286.ditaval
dita:id
tmo1562969305444
Product Category
Teradata Applications

Returns all the values between the given parameter values including the start and end values. The between function is used only within the context of the filter or its functions.

count(
                filter(
                                get("Account.cart"),
                                "price",
                                between(40,45)
                )
) == 3

The example returns true if there are three rows for price that have a value greater than or equal to 40 and less than or equal to 45.