[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
MIN()
Return the smaller of two numeric or date values
------------------------------------------------------------------------------
Syntax
MIN(<nExp1>, <nExp2>) --> nSmaller
MIN(<dExp1>, <dExp2>) --> dSmaller
Arguments
<nExp1> and <nExp2> are the numeric values to be compared.
<dExp1> and <dExp2> are the date values to be compared.
Returns
MIN() returns the smaller of the two arguments. The value returned is
the same data type as the arguments.
Description
MIN() is a numeric and date function that ensures the value of an
expression is smaller than a specified minimum. The inverse of MIN() is
MAX() which returns the greater of two numeric or date values.
Examples
. In these examples MIN() returns the smaller of two numeric
values:
? MIN(99, 100) // Result: 99
? MIN(100, 99) // Result: 99
. In these examples MIN() compares date values:
? DATE() // Result: 09/01/90
? MIN(DATE(), DATE() + 30) // Result: 09/01/90
Files Library is CLIPPER.LIB.
See Also:
MAX()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson