maxDate

Description

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.

Syntax

maxDate(dataset, columnIndex OR date, date...)

Examples

The following table applies to the code snippet below:

AlarmTime

Path

Severity

2010-01-08 7:28:04

Tanks/Tank5/TempHiAlarm

4

2010-01-08 10:13:22

Tanks/Tank38/LoLevel

2

2010-01-08 13:02:56

Valves/Valve2/

2

maxDate({Root Container.Table.data}, "AlarmTime") //You could use this expression to get the date and time for the most recent alarm: