9 Replies Latest reply on Jul 13, 2016 7:06 AM by Phani Kosanam

    Convert string to Day/Date Value

    Phani Kosanam

      Hi,

       

      My datasource has a string value for Days of the week eg:

       

      1st Sunday

      1st Monday

      1st Tuesday

      ...

      ...

      5th Sunday

      5th Monday

      5th Tuesday

       

      I am looking to convert these string values to actual days based on current day

       

      Eg: If my data has 10 rows for 2nd Monday, this should show the date as 7/11/2016 for current date. For next month the date will be 8/8/2016 for these 10 rows.

       

      I was able to achieve the reverse based on current day, but note able to parse based on the above string values.