3 Replies Latest reply on Apr 24, 2018 12:23 AM by Shinichiro Murakami

    Assigning Date on string values on incremental basis

    A Vivek

      Hello all,

       

      I am trying to assign Month and year to a string value. The sales data comes like this

       

      Alias for monthSales Target
      M-31000
      M-22000
      M-11500
      M1000

       

       

      PS: i have given example for M-3 only... in my project it could go up to M-24 --> M so its a huge iteration.

       

      My objective is to set Today's month for M-3  which is april and M-2 will be May and so on

       

      Alias for monthMonthSales Target
      M-3Apr1000
      M-2May2000
      M-1Jun1500
      MJuly1000

       

       

      How can i achieve this? Please help.

       

      Same thing for year in another column. So if i get the month, it will do.

       

      Thanks