Difference between revisions of "MIN()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 32: Line 32:
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Numeric Data]]
 +
[[Category:Numeric Data Functions]]

Revision as of 09:08, 2 June 2009

Class

Numeric Data


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

Recital Database Server, Recital Mirage Server, Recital Terminal Developer