1 Reply Latest reply: Oct 10, 2010 4:43 AM by AndreaPeretti RSS

    come calcolare intervallo di date

       

      I have a problem.
      I have a start date refers to an article and I must be able to calculate the end date for that item.
      is a bit difficult to explain socarry two examples.
      The first table is what I have.
      the second table is what I would like to find.
      in the second table is the end date column that calculates the end date of interval.

      thanks

       

       

      start DataArt FatherArt SonType
      01/10/2010A11A11311
      01/10/2010A11A11451
      01/10/2010A11A11461
      02/09/2010A11A11463
      02/09/2010A11A11453
      02/09/2010A11A11463
      02/09/2010A11A11003
      02/09/2010A11A11853
      01/01/2010A11A1185100
      01/01/2010A11A1103100
      01/01/2010A11A1158100


      start Datadata endArt FatherArt SonType
      01/10/201010/10/2010A11A11311
      01/10/201010/10/2010A11A11451
      01/10/201010/10/2010A11A11461
      02/09/201031/09/2010A11A11463
      02/09/201031/09/2010A11A11453
      02/09/201031/09/2010A11A11463
      02/09/201031/09/2010A11A11003
      02/09/201031/09/2010A11A11853
      01/01/201001/02/2010A11A1185100
      01/01/201001/02/2010A11A1103100
      01/01/201001/02/2010A11A1158100
        • come calcolare intervallo di date

           

          start DataArt FatherArt SonType
          01/10/2010A11A11311
          01/10/2010A11A11451
          01/10/2010A11A11461
          02/09/2010A11A11463
          02/09/2010A11A11453
          02/09/2010A11A11463
          02/09/2010A11A11003
          02/09/2010A11A11853
          01/01/2010A11A1185100
          01/01/2010A11A1103100
          01/01/2010A11A1158100
          start Datadata endArt FatherArt SonType
          01/10/201010/10/2010A11A11311
          01/10/201010/10/2010A11A11451
          01/10/201010/10/2010A11A11461
          02/09/201031/09/2010A11A11463
          02/09/201031/09/2010A11A11453
          02/09/201031/09/2010A11A11463
          02/09/201031/09/2010A11A11003
          02/09/201031/09/2010A11A11853
          01/01/201001/02/2010A11A1185100
          01/01/201001/02/2010A11A1103100
          01/01/201001/02/2010A11A1158100