Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the data like below. for each cr number i have start and end dates in time stamp format ,my requirement is to generate the hourly time stamp between Start and end dates for each cr, please help me how do i achieve the same.
[CR number] | Scheduled Start | Scheduled End |
CR532195 | 14/11/2020 15:00 | 15/11/2020 04:00 |
CR452455 | 14/11/2020 15:30 | 15/11/2020 03:00 |
CR854524 | 14/11/2020 16:00 | 14/11/2020 22:00 |
CR865873 | 14/11/2020 16:00 | 14/11/2020 22:00 |
CR327377 | 14/11/2020 16:00 | 14/11/2020 22:00 |
CR328432 | 14/11/2020 17:30 | 15/11/2020 17:30 |
CR214244 | 14/11/2020 18:30 | 15/11/2020 00:00 |
CR857635 | 14/11/2020 20:00 | 15/11/2020 00:00 |
CR424234 | 14/11/2020 20:00 | 15/11/2020 12:00 |
CR241242 | 14/11/2020 21:00 | 15/11/2020 06:00 |