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

    Convert string to Day/Date Value

    Phani Kosanam



      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.