I am using VBA to program some screens inside the PI ProcessBook, I need to develop a code where I search when determiner value was displayed in the TAG and returns the Date / Time of the event. Is it possible to do this query via VBA?
Your tag will need to have the STEP attribute turned ON.
You can then use the PE function FindEq with IPICalculation.Calculate in PI SDK to get the timestamp value.
Example of PE:
FindEq('cdt158', '*-1h', '*',55.85729)
Retrieving data ...