Tinderbox 7 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.

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.