Returns a Boolean value (TRUE or FALSE) that indicates
whether the time value designated by <number> is
between the lower and upper time value arguments
<time1> and <time2>.
The following are prerequisites for this function:
Both the lower and upper time arguments must
be fully specified. For example, GMT 1995 Jan is
fully specified. But GMT Jan, GMT 1995 20 and
GMT Jan Mon_2 are not fully specified.
Both arguments must be either GMT or Local.
The day of the week must not be present in
either argument. However, the day of the month
can be specified as the first, second, third, or
fourth weekday of the month (example Wed_3 is
the third Wednesday of the month).
The upper time argument, <time2>, must be
bigger than the lower time argument, <time1>.
The following examples assume that the current time
value is GMT 2005 May 1 10h 15m 30s and that the day
is the first Sunday of the month of May in 2005. The
result of the evaluation is given after each example.
BETWEEN(GMT 2004, GMT 2006): TRUE
BETWEEN(GMT 2004 Jan, GMT 2006 Nov): TRUE
BETWEEN(GMT 2004 Jan, GMT 2006): TRUE
BETWEEN(GMT 2005 May Sun_1, GMT 2005 May
Sun_3): TRUE
BETWEEN(GMT 2005 May 1, GMT May 2005 1):
TRUE
BETWEEN(LOCAL 2005 May 1, LOCAL May 2005
1): The result depends
on the NetScaler system's timezone.
Parameters:
<time1> - Lower time value
<time2> - Upper time value