Both End Point Excluded Range operator

---

Creates a range from x to y excluding the value x and y. The following types for x and y are possible: number, boolean, currency, date, time, datetime and string.

Usage:

x _To_ y

Return:

A range from x to y excluding the value x and y.

Examples:

CDate(2005, 01, 01) _To_ CDate(2005, 8, 1)
-> Returns a range beginning with January 2nd, 2005 and ending with July 31th, 2005.

1.000 _To_ 2.000
-> Creates a numeric range beginning with 1.001 and ending with 1.999.

See also:

• Range operators

i-net software strives to provide accurate product documentation. Please give us your feedback using the form below.
NOTE: This form is for documentation feedback only. For technical assistance, please send an email to crystalclear@inetsoftware.de.