Function: Max
Description
This function returns the larger of expr1, expr2, and optionally an arbitrary number of additional parameters. All parameters must be of the same type: numeric, date or character.
Syntax
Max(expr1,expr2[,...])
Arguments
expr can be a constant, a numeric field, a character field, a date field or an expression. Note: In the case of a character field, z would be larger than x.
Return value
This function returns the larger of expr1 and expr2, and optionally an arbitrary number of additional parameters. Accepts numeric, date or character input. Note: In the case of a character field, z would be larger than x.
Calculated field example
If the Test1, Test2 and Test3 fields contained a series of numeric test values, the following calculated field expression would return the difference between the maximum test value and the minimum test value: Max(Test1,Test2,Test3)-Min(Test1,Test2),Test3)
Filter/Find example
Records with a third test value above both the first and second test values can be selected or found using the expression: Test3>Max(Test1,Test2).
This expression is equivalent to the compound expression: Test3>Test1.And.Test3>Test2