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