Skip to main content

Between

Between Function

Determines whether a given number falls within a specified range; returns True if the given number does exist in the specified range.

Syntax

Between(scalar Value, scalar Min, scalar Max)

Arguments

ArgumentDescription
scalar ValueNumber to be evaluated as to whether it falls within the specified range
scalar MinMinimum (starting) number of the range
scalar MaxMaximum (ending) number of the range

Examples:

Between([FusionTestTable.DoubleColumn], 1, 100)

Returns true for all values in column which lie in the specified range.