AnsweredAssumed Answered

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

Question asked by Dr.Zhou on Dec 6, 2018
Latest reply on Dec 7, 2018 by 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

Outcomes