Search…
Resources
Related Links
min
To return the lowest or earliest value of an array
Find with this function the lowest value of an array.
The function works best with an array of numbers or time-related values.

min([any])
min([number])
min([timestamp])

any

min([number]) To return the lowest number of a number array.
min([1, 21, 9, 35])
Result: 1
​
min([date]) To return the earliest date of a date array.
let currYear := year(now());
let list := (select Employees).date(currYear, month(Birthday), day(Birthday));
min(list)
Result: The first birthday of a year (for example of an employee)

​max, which returns the highest or latest value of an array.
Last modified 2mo ago
Export as PDF
Copy link
On this page
Syntax
Return
Examples
See also