Computes the most frequent (mode) 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.


Output: Returns the most frequently appearing Datetime value from the myDates column.


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


Name of the column the Datetime values of which you want to calculate the most frequent (mode) date.

Required?Data TypeExample Value
YesDatetime (column reference)datTransactions