### Make Range operator (x To y)

Basic and Crystal syntax.

##### Usage

`x to y`

Create the range x to y.

##### Examples

The following examples are applicable to both Basic and Crystal syntax:

`100.00 to 250.00`

The range of consecutive numeric values beginning with 100.00 and ending with 250.00, including the end values.

`CDate(1990, 09, 01) to CDate(1990, 09, 20)`

The range of consecutive dates beginning with September 1, 1990, and ending with September 20, 1990. Both September 1 and September 20 are included in the range.

`"Aaron" to "Lusk"`

The range of consecutive text values beginning with "Aaron" and ending with "Lusk", including the beginning and end values.

##### Comments

- You cannot create a formula that has a range as a result. Thus, Make Range is always used in conjunction with other operators such as the In Range operator. The combination of Make Range and In Range produces a formula that gives a single TRUE or FALSE value, not a range.
- The program comes with a number of Date Range functions, such as YearToDate, preset for your convenience.

###### Related topics

Formula 2

Formula 3

Formula 9

Formula 10

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com