binod_tiwary

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

Hi,

 

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

 

 

 

 

 

 

Outcomes