MAX()

From Lianjapedia
Revision as of 07:26, 23 February 2021 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return maximum value function

Syntax

MAX(<exp1>,<exp2>)

See Also

AMAX(), AMIN(), IIF(), MIN(), MOD()

Description

The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.

Example

? max(1, 3)
         3
set date british
? max(ctod("15/10/1997"), ctod("14/10/1997"))
15/10/1997