min

To return the lowest or earliest value of an array

Use this function to find the lowest value or the earliest value in an array.

The function works only with an array of numbers or time-related values.

Syntax

min([any])

min([number])

min([timestamp])

Return

any

Examples

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)

See also

max, which returns the highest or latest value of an array.

Do you want to dive deeper into the topic? Take a look at the corresponding part of our video tutorial.