Max

The Max() function calculates the highest value of a list of numbers, datetimes or durations.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number, datetime or duration that is the highest value of the given values.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

Syntax

Max(List(values) or [field] of [list])

Max(List(1, 2, 5, 3)) => Result: 5

Max(List(45s, 12s, 50s, 1m25s) => Result: 1m25s

Max([Products.Price] of [Products]) => Result: the max Price-value of all products in the list [Products]

Max() => Result: unknown

Parameters

Name	Type	Required	Description
values	list	☑️	the list of values. The values can be either numbers, datetimes or durations.