0 Replies Latest reply: May 1, 2014 12:19 PM by Fernando Barros RSS

    How to split timestamp in work days

      Hi,

       

      I´m openning a new post since I made some confuse.

       

      For example. I have a interval date:

      Start date:28/04/2014 15:31:00

      End Date: 30/04/2014 08:43:00

       

      I would like to have this result, which means all the work days from 09:00 until 18:00.

       

      lStateShiftIDTZStartTZEnd
      24128/04/2014 15:3128/04/2014 18:00
      24228/04/2014 09:0029/04/2014 18:00
      24329/04/2014 09:0029/04/2014 08:43

       

      I was trying to see this Splitting the data - On the way to granularity, but I couldn´t make in my way.

       

      Any help would be appreciated.

       

      Best Regards

      Fernando