Please find the below,
1, the first day of the last month; Bom(Bom('*')-1)
2, the last day of the last month; Bod(Bom('*')-1)
3, the first day of the last year; ParseTime(Concat("01-Jan-",Year('*')-1))
4, the last day of the last year; ParseTime(Concat("31-Dec-",Year('*')-1))
Hope this helps
Thanks for the quick response. But those syntax come from Performance Equation family. Could they be employed in DataLink? I'm afraid not.
1 of 1 people found this helpful
If it is DataLink, we can utilize the power of excel formula and reference the cells accordingly with the PI DataLink functions. That would be best option.
You're right. To have Excel formula involved, which was my option after being stuck yesterday, is a great way to strengthen the DataLink capabilities.
I was just wondering whether I were using DataLink fuctions in the wrong way.
Thanks for your advice.