MAX function will find the maximum value of an array of numbers or dates.


Syntax


MAX([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


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


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