Difference between revisions of "MIN()"

From Lianjapedia
Jump to: navigation, search
Line 23: Line 23:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
[[Category:Numeric Data]]
 
 
[[Category:Numeric Data Functions]]
 
[[Category:Numeric Data Functions]]

Revision as of 09:07, 4 February 2013

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

Products

Lianja Server, Lianja