1 Reply Latest reply: Apr 3, 2018 4:03 PM by Rupam Das RSS

    add dates in between and rearrange the format from columns to rows

    Michael Angelo Medaflor

      Please if you can help me add dates in between and rearrange the format from columns to rows

          Mytable

      VacStartDateVacEndDateEmp
      28/01/201802/02/2018140115
      23/01/201824/01/2018140009

       

       

        Desired results.

      DateEmp
      28/01/2018140115
      29/01/2019140115
      30/01/2020140115
      30/01/2021140115
      31/01/2022140115
      01/02/2023140115
      02/02/2024140115
      23/01/2018140009
      24/01/2018140009

       

       

      Regards,

       

      Mike