minDate
Description
Finds and returns the minimum date in the given column of the given dataset, or the min value in a series of dates specified as arguments. When looking up the min 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
minDate(dataset, columnIndex OR date, date...)
Examples
For example, suppose you had a Table with this dataset in it:
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 |
minDate({Root Container.Table.data},
"AlarmTime"
)
//You could use this expression to get the date and time for the oldest alarm