0 Replies Latest reply: Jan 25, 2011 8:51 AM by ErikssonM RSS

    create a column based on dates from different rows

    ErikssonM

      Hello!

      Any ideas on how to make a table based on a criteria (end date (row 1) - start date(row 2)) for when "consecutive" dates belongs to a the new period. The periods belongs to a certain person.

       

      PersonStart_dateEnd_datePeriod
      A2010-01-012010-01-021
      A2010-01-032010-01-042
      A2010-01-102010-01-103
      PersonPersonStart_dateOld periodPeriod
      A2010-01-012010-01-0211
      A2010-01-032010-01-0421
      A2010-01-102010-01-1032

       

      Kind Regards,

      Markus