6 Replies Latest reply: Nov 11, 2011 8:09 PM by John Witherspoon RSS

    How to create dates Dates in a Range?

    Leandro Duarte

      Dear Colleagues,

       

      I need a help to create in a easy way period of datas for a price range table.

       

      I'm using the solution Interval match with a calendar, but I would like to create it in the same table, today it is creating a $Syn Table.

       

      11-11-2011 10-08-45 AM.jpg

       

      I have the following data for example:

       

       

      DatefromDataToProductvalue
      Jan-2011Mar-2011a10
      Feb-2011Mar-2011b20
      Apr-2011Jun-2011a12
      May-2011Aug-2011b19

       

      The results expected are the following:

       

      MonthProductValue
      Jan-11a10
      Feb-11a10
      Mar-11a10
      Apr-11a12
      May-11a12
      Jun-11a12
      Feb-11b20
      Mar-11b20
      Apr-11b20
      May-11b19
      Jun-11b19
      Jul-11b19
      Aug-11b19

       

      I really appreciate if somebody can help me to do it smartelly.  

       

      Thanks in advance,

      Leandro Duarte