+---------------------------------+
|             BETWEEN             |
+---------------------------------+
BETWEEN(<expr1>, <expr2>, <expr3>)

-----------------------------------
Determines if expression lies between two other expressions.
Return value - Logical
-----------------------------------

True is returned if <expr1> is greater than or equal to <expr2> and less
than or equal to <exp3> (<expr2> <= <expr1> <= <expr3>); otherwise false
is returned.

<expr1>
        Expression to be tested.

<expr2>
        Low expression.

<expr3>
        High expression.

+---------------------------------+
|             Example             |
+---------------------------------+
In this example, INVOICE database is scanned for all records for which
payment is due, but not more than 30 days overdue.

USE invoice
SCAN FOR BETWEEN(inv_date, DATE() - 30, DATE())
        ? 'Send notice of payment due for ' + company
ENDSCAN

-----------------------------------

See Also:  MAX(), MIN()

-----------------------------------