MIN function will find the minimum value of an array of numbers or dates.


Syntax


MIN([x,x,x,x,x])


Parameters


x = The array of either dates or numbers.


Data Type Returned


Will return either a number or date depending on the array set by the user.


Example


MIN([1,2,3,4,5,6]) will return a value of 1.


MIN([DATE(2019,01,01), DATE(2019,01,02)]) will return 01 Jan 2019.