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 */
