MicroStrategy ONE

Between

Returns TRUE if the specified value is between the inclusive range of two boundaries. Between can be used to test if a value is within a valid data range.

Syntax

Value Between Boundary1 and Boundary2

Where:

Value, Boundary1, and Boundary2 can be numbers, date/time, text, or functions that return the mentioned data types. Value, Boundary1 and Boundary2 must be of the same data type.

Example

  • M1 Between 1 and 1000
  • region@DESC Between "A" and "Z"
  • date@DESC Between '1999-2-12' and '2005-2-23'