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()