4 Replies Latest reply: Jun 27, 2017 6:39 AM by Prashanth Reddy RSS

    Extract Dates from Date Range

    Prashanth Reddy

      Hi,

       

      I'm working on data which extracted from Google Calendar where the users update their PTOs, Work From Home, etc. I'm able to extract the info but I need it in a different format.

       

      Extracted Info:

      In above example, 1st row date range is from 3rd May to 11th May (total 6 Days). But I want to represent the same in 6 rows as 5th May, 6th May till 10th May as I need to exclude weekends or if any public holidays.

       

      Ex: Output should be like below (For 1st Row and so on)..

       

      Kiran Gade PTO           Kiran           PTO           2017-03-05
      Kiran Gade PTO           Kiran           PTO           2017-03-06
      Kiran Gade PTO           Kiran           PTO           2017-03-07
      Kiran Gade PTO           Kiran           PTO           2017-03-08
      Kiran Gade PTO           Kiran           PTO           2017-03-09
      Kiran Gade PTO           Kiran           PTO           2017-03-10

       

      In some cases, start and end date values are showing as

      Start -  2016-08-19T00:00:00+05:30

      End - 2016-08-19T01:00:00+05:30

       

      Thanks,

      Prashanth Reddy D.