Top | Previous | Next |
Aggregates / maxDate |
maxDate(dataset, columnIndex OR date, date...) Finds and returns the maximum date in the given column of the given dataset, or the max value in a series of dates specified as arguments. When looking up the max date in a dataset, the column may be specified as an index or as a column name. Any null values in the column are ignored. If there are no rows in the dataset, null is returned.
For example, suppose you had a Table with this dataset in it:
You could use this expression to get the date and time for the most recent alert: maxDate({Root Container.Table.data}, "AlertTime") |