Tinderbox v8 Icon

between(value,min,max)


Operator Type: 

Operator Scope of Action: 

Operator Purpose: 

Operator First Added: 

Operator Altered: 

 Function   [other Function type actions]

 Item   [operators of similar scope]

 Query Boolean   [other Query Boolean operators]

 Baseline

 


between(value,min,max)

Returns Boolean true if the value is greater or equal to min and less than max. The comparison method is based on the type of value; numerical, lexical, string and set comparisons are chosen as needed.

The logic is:

((value >= min) & (value < max))

Thus between() is true if value==min but false if value==max.

If $MyNumber is 7, then:

$MyBoolean = between($MyNumber, 1, 5); is false

$MyBoolean = between($MyNumber, 1, 9); is true

More realistically the operator would be used in a query or a conditional expression:

if(between($MyNumber, 1, 5)){…}else{…}; would test as true and execute the code in the first conditional branch.

Do not use this operator for testing Date-type attributes directly. Either use days() instead or use between() with format() or Date.format() to create a suitable string values for testing.

In the query creation pop-ups of agent and Find dialogs this function is listed as "is between".

This replaces the legacy #between query operator.