Difference between revisions of "MIN()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Yvonne.milne (Talk | contribs) |
||
(2 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the minimum value | Function to return the minimum value | ||
− | |||
==Syntax== | ==Syntax== | ||
MIN(<exp1>, <exp2>) | MIN(<exp1>, <exp2>) | ||
− | |||
==See Also== | ==See Also== | ||
[[AMAX()]], [[AMIN()]], [[IIF()]], [[MAX()]], [[MOD()]] | [[AMAX()]], [[AMIN()]], [[IIF()]], [[MAX()]], [[MOD()]] | ||
− | |||
==Description== | ==Description== | ||
The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types. | ||
− | |||
==Example== | ==Example== | ||
Line 23: | Line 19: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | |||
[[Category:Numeric Data Functions]] | [[Category:Numeric Data Functions]] |
Latest revision as of 07:26, 23 February 2021
Contents
Purpose
Function to return the minimum value
Syntax
MIN(<exp1>, <exp2>)
See Also
AMAX(), AMIN(), IIF(), MAX(), MOD()
Description
The MIN() function returns the lesser of two expressions <exp1> and <exp2>. These expressions can be of numeric or date data types.
Example
? min(1, 3) 1 ? min(ctod("01/02/1997"), date()) 01/02/1997