I am very new to PI so please excuse me if this is something very obvious.
My requirement is very simple, I am trying to set the value of an AF attribute by using a 'Formula'. My formula will look like below as I need to return a pre defined value depending on the current month:
If CurrentMonth="April" Then 100 else if CurrentMonth="May" Then 200 else if CurrentMonth="June" Then 800 ..............and so on.
My problem is how to get the current date (is there something equivalent of SQL server GetDate() function in Pi AF) which I can use to work the current month use in the formula.
Any suggestion please. If any alternate approach should be taken