max()

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

Syntax

max(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 max() function can’t be used for date or time values.

Documentation Feedback

---