MIN()

From Lianjapedia
Jump to: navigation, search

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