Start to End Spanning Dates

[cfountain72]

Good Morning,

I think this can be done in SQL, but I was wondering if any Qlik magic can accomplish the same. We are tracking different timeframes that need to be broken up across their separate dates. For instance:

Start Date: 11/1/2021 @ 10PM  to  End Date: 11/3/2021 @ 3AM

We would want to end up with three rows for this timeframe, showing the hours in each day:

11/1/2021: 2   (10PM to midnight)

11/2/2021: 24   (the whole day)

11/3/2021: 3  (midnight to 3AM)

Thanks in advance for any suggestions,

Chris

[MarcoWedel · Accepted solution]

Maybe helpful:
https://community.qlik.com/t5/QlikView-App-Dev/Split-duration-time-into-seperate-records-per-date/td...

[cfountain72]

Thanks! Took some modifications for my purposes, but this was a great starting point.