BETWEEN( )The first value in the range of values to which to compare. String and date values must be enclosed in double quotation marks (" ").The second value in the range of values to which to compare. String and date values must be enclosed in double quotation marks (" ").True if value is between upperBound and lowerBound, or equal to upperBound or lowerBound; returns false otherwise.The following example tests each value in the SalesTotal data field to see if the value is between 10000 and 20000:The following example tests each value in the CustomerName data field to see if the value is between A and M:The following example tests each value in the ReceiptDate data field to see if the value is between 10/01/07 and 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 5 days to the orderDate value. If an orderDate value is in a month other than December, add 3 days to the orderDate value.IF((BETWEEN([orderDate], "12/1/07 12:00 AM", "12/31/07 12:00 AM")), (ADD_DAY([orderDate], 5)), (ADD_DAY([orderDate], 3)))
|
|
Copyright Actuate Corporation 2012 |