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.
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.
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)
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