Returning earliest date in a dataset with an expression?

Ignition
1

Hey y’all,

As always I appreciate any help I can get. I have dataset tags that I need to parse and return the earliest and latest date for. I have searched the forums and haven’t come up with much. Script or expression doesn’t matter.

Times are formated as: 2019-07-17 11:13:19.779

2

Use the sortDataset function, then return the first row; something like:
sortDataset({reference.to.dataset}, "timestamp")[0, "timestamp"]

1 Like
3

An expression example, for completeness:

minDate({Root Container.Power Table.data},'Date Column')
3 Likes
4

:doh: forgot about minDate entirely.

1 Like