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) |
| Argument | Required? | Data Type | Description |
|---|---|---|---|
| function_col_ref | Y | string | Name of column to which to apply the function |
Name of the column the Datetime values of which you want to calculate the minimum date.
| Required? | Data Type | Example Value |
|---|---|---|
| Yes | Datetime (column reference) | datTransactions |