2 Replies Latest reply: May 6, 2018 11:16 PM by ahmad albab RSS

    How should I create new field in load script (select last 12 month date)?

    ahmad albab

      Dear Team,

       

      I want to create new field in load script using if else.

       

      For example field "Last12Month", it will only select last 12 month period exclude this month.

       

       

      I want to create few field:

       

      a) Last12Month

      b) Last24Month

      c) Last36Month.

       

       

      Please help.

       

      Thanks.

       

      period script.PNG

      period table.PNG