min()

The min() function returns the number with the lesser value from a set of two numeric fields, constants or expressions.

Syntax

min(num1, num2)

Parameters

• num1 – Numeric field, constant or expression you wish to compare to the value in the num2 parameter.

• num2 – Numeric field, constant or expression you wish to compare to the value in the num1 parameter.

Return value

Numeric

Comments

The min() function can’t be used for date or time values.

Documentation Feedback

---