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]
Already in v5.0.0
between(value,min,max)
Returns 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.