Difference between revisions of "MIN()"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
 
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Function to return the minimum value
 
Function to return the minimum value
Line 27: Line 25:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data]]
 
[[Category:Numeric Data Functions]]
 
[[Category:Numeric Data Functions]]

Latest revision as of 17:09, 3 December 2009

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 Server, Recital