Between(value, min, max)

Checks if the value is greater than or equal to min and less than or equal to max.

Parameters

value

The column, expression, or literal value to test.

min

The minimum value of the range. Can be a column, expression, or literal value.

max

The maximum value of the range. Can be a column, expression, or literal value.

Returns

Boolean

Examples

• Between([Check Date], [From Date], [To Date]) returns true if the "Check Date" value is greater than or equal to "From Date" and less than or equal to "To Date" value.