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 sidesBetween(50, 25, 100, 'left') Inclusive only left sideBetween(50, 25, 100, 'right') Inclusive only right side 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 |