1 Reply Latest reply on Jul 28, 2016 8:55 AM by khalid norat

    Distribute Start-End Time Data over days or weeks

    Daniel Ames

      Perhaps this is possible with a cross join, but I haven't been able to figure it out.

       

      I have data that includes a start-time and an end-time that could span multiple days. I would like to divide up the time interval to only see hours of the interval relevant to a particular day or week.

       

      For example:      StartTime = 4/15/2016 7:00 AM

                                 EndTime = 8/16/2016 6:00 AM

       

      How can I see the hours/days from this time interval distributed over individual days/weeks? For instance, only the week of 6/19/2016?

       

      Thanks for any and all assistance.