Between

Syntax

Between(x, LowerBound, UpperBound)

Description

Test if a value is between two other values.  Between(x, LowerBound, UpperBound)  is equivalent to And((x >= LowerBound), (x <= UpperBound))

Examples

Between(1, 0, 2) = True
Between(0, 0, 2) = True
Between(-1, 0, 2) = False
Between(1, 2, 0) = True       LowerBound and UpperBound can be reversed.
Between(Year, 2005, 2010) = True if the year is in the range 2005-2010.