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