2 Replies Latest reply: Mar 20, 2013 9:48 AM by Andreas Lindholm RSS

    convert weekday to a date

      Hi,

       

      I have a list of articles and weekdays they arrive.

       

      Example:

       

       

      ArticleArrivalDay 1ArrivalDay 2
      Article1MondayFriday
      Article2WedensdayFriday
      Article3MondayTuesday
      Article4TuesdayThursday

       

      Today is 20-03-2013, and I wonder if there is any way to convert the weekdays to Dates... The date should be the first upcoming date (or todays date) that matches the weekday.. euhm.. my bad english makes it hard to explain

       

      Anyway, result that I want is this:

       

       

      ArticleArrivalDate 1Arrival Date 2
      Article125-03-201322-03-2013
      Article220-03-201322-03-2013
      Article325-03-201326-03-2013
      Article426-03-201328-03-2013

       

      Any help is appreciated

       

      thanks in advance.