Built-in Functions → between

between() is a boolean function that determines whether the value resulting from evaluating an expression fits within the defined range by evaluating the min and max expressions. The range is inclusive of the boundary values. If the value fits within the range, the function returns true, otherwise, it returns false.

Signature

between(exp value, exp min, exp max)
  • value : value to test
  • min : lower limit of test range
  • max : upper limit of test range

Returns

bool

Example

Determine whether AMOUNT_SOLD is between 1000 and 2000.

between(Sales_Acme.Sales.AMOUNT_SOLD, 1000, 2000)