Difference between revisions of "MAX()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return maximum value function | Function to return maximum value function | ||
− | |||
==Syntax== | ==Syntax== | ||
MAX(<exp1>,<exp2>) | MAX(<exp1>,<exp2>) | ||
− | |||
==See Also== | ==See Also== | ||
[[AMAX()]], [[AMIN()]], [[IIF()]], [[MIN()]], [[MOD()]] | [[AMAX()]], [[AMIN()]], [[IIF()]], [[MIN()]], [[MOD()]] | ||
− | |||
==Description== | ==Description== | ||
The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | The MAX() function returns the greater of the two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
15/10/1997 | 15/10/1997 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 12:58, 11 December 2012
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
Products
Lianja Server, Lianja