The Max()
function calculates the highest value of a list of numbers, datetimes or durations.
Syntax
Max(values)
Returns
A number, datetime or duration that is the highest value of the given values
.
Parameters
values
– the list of values of which the highest value is be calculated. The values can be either numbers, datetimes or durations.
Examples
Max([Products.Price] of [Products])
/* returns the highest price of all the products in the list */
Max([Products.Price] of [Products] where [Products.Category] = 'Guitar')
/* returns the highest price of all the guitars in the list */
Max([Appointments.Duration] of [Appointments])
/* returns the longest duration of all the appointments in the list */
Max(List(1, 3, 6, 2))
/* returns 6 */