[<<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