I need to find the time of a pipoint change its a manual entry input and i need to know when it is changed for the last time!
You can use PI builder --> PI Point -->change date attribute to check when pipoint was last changed. You can also check using PI OLEDB to check the same. If you are looking for the data change, you can use PrevEvent PE.
i need to read it automatically true excel vba is that also possible?
If you are not writing out of order data to the PI Point, you can just read the Snapshot property of the PIData object and obtain the timestamp of the snapshot.
Otherwise, another method of tracking changes to a PIPoint's value is through use of the EventPipe property of the PIData object.
Would you have have the option to use AF Analysis to write the timestamp to an attribute for your use? Can use the PrevEvent call for that tag and write it to an attribute.
yes that's possible, do you also know how to write the PrevEvent call in vba?
what i meant was that in AF Analytics you could have an analysis for this calculation done, then write the output to an attribute. from there, just display that new attribute on the sheet instead of writing it in vba. I do not know the vba that would be required for it as we do ours in AF Analytics.
Retrieving data ...