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