BETWEEN( )The first value in the range of values to compare to. String and date values must be enclosed in double quotation marks (" ").The second value in the range of values to compare to. String and date values must be enclosed in double quotation marks (" ").True if source is between target1 and target2, or equal to target1 or target2; returns false otherwise.The following example tests each value in the SalesTotal field to see if the value is between 10000 and 20000:The following example tests each value in the CustomerName field to see if the value is between A and 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: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))
|
|
Copyright Actuate Corporation 2012 |