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.


modedate(myDates)

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

modedate(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 most frequent (mode) date.

Required?Data TypeExample Value
YesDatetime (column reference)datTransactions