How to get current date in PI AF formula?

Discussion created by binod_tiwary on Oct 22, 2014
Latest reply on Nov 19, 2014 by binod_tiwary



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