FindEq (Tag-based PE function)

Find the timestamp closest to starttime, within the given range, for which the point was equal to the given value.

Syntax

FindEq(tagname, starttime, endtime, value)

Arguments

tagname

A tagname enclosed in single quotes.

starttime

A time expression representing the beginning of the time range to search Relative times are relative to endtime if endtime is not itself a relative time.

endtime

A time expression representing the end of the time range to search. Relative times are relative to starttime if starttime is not itself a relative expression. If endtime is earlier than starttime, the range is searched backwards.

value

Must be an integer or real number or digital state (character string), the value to search for.

Returns

The timestamp closest to starttime, within the given range, for which the point was equal to the given value.

Exceptions

If the point was never equal to the given value, FindEq returns an error value.

Notes

FindEq interpolates between Archive events, if necessary, to find the value it is looking for.

Example

FindEq('tag1', 't', '*', 40.0)

FindEq('digitaltag', '-1d', '*', TagVal('digitaltag', '14-Dec-97'))

FindEq('digitaltag', '14-Dec-97', '*', "On")