Forum Discussion

BastiB's avatar
BastiB
Regular Visitor
4 years ago
Solved

Creating similar rows for a date period

Hello there,

 

I have rows which each contain a start and an end date. Now I want to duplicate each row for each date that lies within this date period (Like shown in the example pictures). That should result in a row for every date.

I already tried something with DATESBETWEEN, but that didn't work out. And I haven't found a suitable solution in existing threads.

 

Thank You!

 

Basti

 

Initial raw dataHow it should look like

2 Replies