Hello Community,
I want to generate rows in the difference of 3 hours for complete days between two dates.
Input:
Start_Time | End_Time |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 |
Output:
Start_Time | End_Time | Time |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 00:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 03:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 06:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 09:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 12:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 15:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 18:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-04 21:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 00:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 03:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 06:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 09:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 12:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 15:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 18:00:00 |
2022-23-04 00:00:00 | 2022-23-05 23:59:59 | 2022-23-05 21:00:00 |
Use the Generate Rows tool and configure to add three hours between start and end: DateTimeAdd([Time],3,"hour")