Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
does someone have a Clue how I should solve this?
What I try to do is create a working schedule With these input.
script or frontend doesnt matter.
Date | starttime | Endtime | ScheduleID |
2018-03-04 | 19:00 | 20:45 | 18 |
2018-03-04 | 21:00 | 23:59 | 18 |
2018-03-05 | 00:00 | 06:30 | 17 |
2018-03-05 | 22:48 | 23:59 | 17 |
2018-03-06 | 00:00 | 06:30 | 17 |
2018-03-06 | 22:48 | 23:59 | 17 |
2018-03-07 | 00:00 | 06:30 | 17 |
2018-03-07 | 22:48 | 23:59 | 17 |
2018-03-08 | 00:00 | 06:30 | 19 |
Expected | |||
2018-03-04 | 19:00 | 2018-03-05 | 06:30 |
2018-03-05 | 22:48 | 2018-03-06 | 06:30 |
2018-03-06 | 22:48 | 2018-03-07 | 06:30 |
2018-03-07 | 22:48 | 2018-03-08 | 06:30 |
Hi,
what is the logic here to have this expected result?
what is the calculation rules ?
Hi Youssef, I'll think Logic is what we have to find here, because there is any yet.
I have try to use if combinied With Group by.
like if ScheduleID is 18 then use the min value of starttime and if if ScheduleID is 17 it will use min of Endtime.