1 of 1

Min

The Min() function calculates the lowest value of a list of numbers, datetimes or durations.

This function is SQL compatible. For more information about SQL compatibility, see our documentation.

Returns a number, datetime or duration that is the lowest value of the given values.

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

Min(List(values) or [field] of [list])

Min(List(1, 2, 5, 3))=>Result: 1

Min(List(45s, 12s, 50s, 1m25s)=>Result: 12s

Min([Products.Price] of [Products])=> Result: the min Price-value of all products in the list [Products]

Min()=>Result: unknown

Name

Type

Required

Description