BETWEEN( )
Tests if a value is between two specified values.
Syntax
BETWEEN(source, target1, target2)
Arguments
source
The value to test. The value can be a string, numeric, or date value.
target1
The first value in the range of values to compare to. String and date values must be enclosed in double quotation marks (" ").
target2
The second value in the range of values to compare to. String and date values must be enclosed in double quotation marks (" ").
Returns
True if source is between target1 and target2, or equal to target1 or target2; returns false otherwise.
Examples
The following example tests each value in the SalesTotal field to see if the value is between 10000 and 20000:
BETWEEN([SalesTotal], 10000, 20000)
The following example tests each value in the CustomerName field to see if the value is between A and M:
BETWEEN([CustomerName], "A", "M")
The following example tests each value in the ReceiptDate field to see if the value is between 10/01/07 and 12/31/07:
BETWEEN([ReceiptDate], "10/01/07", "12/31/07")
The following example uses BETWEEN( ) in conjunction with the IF( ) and ADD_DAY( ) functions to calculate a shipment date. If an orderDate value is in December 2007 (between 12/1/07 and 12/31/07), add five days to the orderDate value. If an orderDate value is in a month other than December, add three days to the orderDate value.
IF(BETWEEN([orderDate], "12/01/07", "12/31/07"), ADD_DAY([orderDate], 5), ADD_DAY([orderDate], 3))

Additional Links:

Copyright Actuate Corporation 2012