min
To return the lowest or earliest value of an array
Find with this function the lowest or earliest 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.1
min([1, 21, 9, 35])
Result: 1
min([date]) To return the earliest date of a date array.1
let currYear := year(now());
2
let list := (select Employees).date(currYear, month(Birthday), day(Birthday));
3
min(list)
Result: The first birthday of a year (for example of an employee)
Last modified 5mo ago