5 Replies Latest reply: Apr 14, 2016 9:11 AM by Onno van Knotsenburg RSS

    Date generation

    Mathieu Bolzinger

      Dear all,

       

      Here is my problem, I have 3 columns, 1 ID, 1 Start date and 1 End date from an Excel spreadsheet. What I would like to is create a table in the script with 2 columns: the ID duplicated and the detail of each day (example hereafter).

       

       

      OperationStartEnd
      A01/03/201604/03/2016
      B08/09/201712/09/2017

      ==>

       

      OperationDate
      A01/03/2016
      A02/03/2016
      A03/03/2016
      A04/03/2016
      B08/09/2017
      B

      09/09/2017

      B10/09/2017
      B11/09/2017
      B12/09/2017

       

      This is my first post, so please let me know if I did something wrong.

       

      Thanks in advance

      Mathieu