Computes the maximum value found in all row values in a Datetime column.

If a row contains a missing or null value, it is not factored into the calculation. If no Datetime values are found in the source column, the function returns a null value.


maxdate(myDates)

Output: Returns the maximum Datetime value from the myDates column.

maxdate(function_col_ref)


ArgumentRequired?Data TypeDescription
function_col_refYstringName of column to which to apply the function


function_col_ref

Name of the column the Datetime values of which you want to calculate the maximum date.

Required?Data TypeExample Value
YesDatetime (column reference)datTransactions