Generate rows between two dates and time

[tushar_portal]

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

[amanda_payne]

Use the Generate Rows tool and configure to add three hours between start and end: DateTimeAdd([Time],3,"hour")