AnsweredAssumed Answered

Using .InterpolatedValues in VBA

Question asked by IJourneaux on Mar 21, 2017
Latest reply on Mar 23, 2017 by IJourneaux

I think I am starting to figure things out for my project. I am working with VBA is Excel. This code works for the time being but there are a couple of more things I would like to accomplish.

        Set pt = server.PIPoints(tagarray(i - 1))

        Set pivalues = pt.Data.InterpolatedValues(StartDateTime, EndDateTime, 4000, "")

 

1. Rather than specifying 4000 data points, I would like to get the data returned with a specific period (i.e. "1h") between startdatetime and enddatetime. It doesn't look like InterpolatedValues2 is available.

2.  Wrt to filtering, is there document that would have some good examples on specifying the filtering. I would like to only retrieve data when a different tag is at a specified value or between two values.

Take Care

Ian

Outcomes