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

 +31 (0)20 240 21 20       

Videos and images courtesy of WEM Modeler. © 2019. WEM Modeler.
SitemapPrivacy - Terms - Company

 +31 (0)20 240 21 20       


Videos and images courtesy of WEM Modeler.
© 2019 WEM Modeler.
SitemapPrivacy - Terms - Company