| Operator Type: | Function |
| Operator Scope of Action: | Item |
| Operator Purpose: | Boolean (query) |
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.
