0
max
To return the highest or latest value of an array
Use this function to find the highest value or the latest value in an array.
The function works only 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.
max([1, 21, 9, 35])Result: 35
max([date]) To return the latest timestamp of a timestamp array.
let currYear := year(now());
let list := (select Employees).date(currYear, month(Birthday), day(Birthday));
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.
Reply
Content aside
Related Articles