Computes the minimum 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.


mindate(myDates)

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

mindate(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 minimum date.

Required?Data TypeExample Value
YesDatetime (column reference)datTransactions