PITimeDat()
- Last UpdatedNov 21, 2022
- 1 minute read
- PI System
- PI DataLink 2023 SP1
- Visualization
Returns actual or interpolated sample values of a PI point or PI AF attribute at specified time stamps.
Syntax
PITimeDat(DataItem, TimeStamps, RootPath, Mode)
Arguments
|
Argument |
Type |
Description |
|---|---|---|
|
DataItem |
String |
The PI point name or PI AF attribute name for which the function returns values. Specify a range of cells that contain PI point names or PI AF attribute names to return values for each. |
|
TimeStamps |
Reference |
A reference to one or more worksheet cells that contain time stamps for which the function returns values. See Time inputs. |
|
RootPath |
String |
The path to the data item. See Data items. |
|
Mode |
String |
The method the function uses to retrieve data:
|
Returns
Values at the specified time stamps, presented in the same orientation as the time stamp reference. If the time stamp reference is a row, the function presents values in a row. If the time stamp reference is a column, the function presents values in a column. The orientation of the output array must match the orientation of the time stamp reference.
Example
=PITimeDat("sinusoid",b1:b12,"","interpolated")
Retrieves interpolated values at the time stamps located in cells B1 through B12 for the PI point sinusoid on the default Data Archive server.
This function requires a twelve-cell horizontal output array, such as C1:C12 or B14:B25.