4 Replies Latest reply on Dec 7, 2018 3:09 AM by Dr.Zhou

    How DataLink intepret the first/last day of the last month/year

    Dr.Zhou

      Dear All,

       

      When I try to generate monthly report for the last month, I wrote the DataLink formula as,

      =PIAdvCalcDat("ct158","bom(bom('*')-1)","bom('*')","1h","average","time-weighted", 0, 1, 0,)

       

      then I got the warning like,

      The time is invalid

       

      I realize the PE syntax may not be suitable here. (https://pisquare.osisoft.com/message/52412#comment-52412)

       

      Could you please remind me of any approaches that I could get the DataLink Time syntax correctly for,

      1, the first day of the last month;

      2, the last day of the last month;

      3, the first day of the last year;

      4, the last day of the last year.

       

      Thanks in advance!

      Sincerely

      ZYY

      2018.12.06