AnsweredAssumed Answered

Excel Time/Date Formulas in PI DataLink

Question asked by vanhunk on Jan 24, 2017
Latest reply on Jan 24, 2017 by afink

In Excell using Pi DataLink, can Excell Time/Date formulas, such as "=DATE(YEAR(C10),MONTH(C10),1) 1" be used for "Start time" and "End time" in PI formulas?

 

If possible, what would the Syntax be? 

 

The following does not work:=PIAdvCalcDat('2017'!$C$11,"DATE(YEAR(C10),MONTH(C10),1)","DATE(YEAR(C10),MONTH(C10),1)+1","1d","average","time-weighted",0,1,0,)

 

Regards,

Henk

Outcomes