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.