Search…
⌃K
Links

max

To return the highest or latest value of an array
Find with this function the highest or the latest value of an array.
The function works best with an array of numbers or time-related values.

Syntax

max([any])
max([number])
max([timestamp])

Return

any

Examples

max([number)] To return the highest number of a number array.
1
max([1, 21, 9, 35])
Result: 35
max([date]) To return the latest timestamp of a timestamp array.
1
let currYear := year(now());
2
let list := (select Employees).date(currYear, month(Birthday), day(Birthday));
3
max(list)
Result: The last birthday of a year (for example of an employee)

See also

min, which returns the lowest or earliest value of an array.
Last modified 1mo ago