Does anyone know if there is a PI Datalink function to return a timestamp when a historian point equals a certain value?

Specifically, I'm trying to populate a regulatory excel report with a bunch of lab data that I'm taking in through string and numeric inputs in FT.

I'm trying to look at the timestamp for the integer that is the date associated with the lab data. Then I will pull the associated data for other historian points in that same range of time (the data all gets moved or copied at one time by the PLC in a couple of seconds). The operators/lab techs get caught up entering multiple days at one time, or I'd just look at each days' value.

Nothing stuck out at me in the PI Datalink manual.

Parents Reply
  • Thanks (Missing Content)​ 

     

    =PIExpVal("FindEq('JC_300_LAB_DATA_DATE','22-Jan-24','25-Jan-24',20230102)","25-Jan-24",0,"")

     

    The above formula returns the timestamp. I've tried various expression syntax to replace the dates with cell references, with no success. Any guidance?

     

    **NEVERMIND, P.104 OF THE MANUAL EXPLAINS HOW TO SPLIT THE EXPRESSION, INSERT THE CELL REFERENCES, AND CONCATENATE IN ANOTHER CELL

Children
No Data