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 1
Between(50, 25, 100, 'both') Inclusive both sides
Example 2
Between(50, 25, 100, 'left') Inclusive only left side
Example 3
Between(50, 25, 100, 'right') Inclusive only right side
Example 4
Between(50, 25, 100, 'none') No inclusive
Parameters
| Name | Type | Description | Required |
|---|---|---|---|
| testvalue | xxxx | xxxx | xxxx |
| minvalue | xxxx | xxxx | xxxx |
| maxvalue | xxxx | xxxx | xxxx |
| inclusive | xxxx | xxxx | xxxx |