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.
lState | ShiftID | TZStart | TZEnd |
24 | 1 | 28/04/2014 15:31 | 28/04/2014 18:00 |
24 | 2 | 28/04/2014 09:00 | 29/04/2014 18:00 |
24 | 3 | 29/04/2014 09:00 | 29/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