Views:

Description

Returns true if a test value lies between 2 other values. Works with numbers and date fields.

Signature

Between('testvalue', 'minvalue', 'maxvalue', 'inclusive')

Example

Between(50, 25, 100, 'both') Inclusive both sides
Between(50, 25, 100, 'left') Inclusive only left side
Between(50, 25, 100, 'right') Inclusive only right side
Between(50, 25, 100, 'none') No inclusive

Parameters

NameTypeDescriptionRequired
testvaluexxxxxxxxxxxx
minvaluexxxxxxxxxxxx
maxvaluexxxxxxxxxxxx
inclusivexxxxxxxxxxxx

Notes: