{{getMsg('Help_YouAreHere')}}: {{page.title}} {{page.title}}

Right End Point Excluded Range operator

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

Usage:

x To_ y

Returns:

Returns a range from x to y excluding the value y.

Examples:

CDate(2005, 01, 01) To_ CDate(2005, 8, 1)
-> Returns a range beginning with January 1st, 2005 and ending with July 31th, 2005.
1.000 To_ 2.000
-> Creates a numeric range beginning with 1.000 and ending with 1.999.