Open items between two dates (Which are fields)

[jcollare]

Hi all!  I have an issue I am really struggling with.

I have two dates, basically, a start date and an end date.  The time between two dates, the event was open.  Each event has a different start date and different end date.  I need to make a trend line to show how many events were open on a given date.  So if the start date was 6/1/23 and the end date was 6/30/23, I need that to show open on my trend line for that period of time in between.  Any ideas?

Thanks in advace!

[Qiu]

@jcollare 
It will be better if you could provide some sample input and output so we can take a closer look.

[terry10]

Use the Generate Rows tool. Example workflow attached. 

If my reply helped you, please mark it accepted. Thanks!