Configuring data for multiple dates

[aiubxh8]

I have a data set with a Start Date and End Date. I would like to configure the data so that there is one record for each month from start date to end date. For example, I have an event with Start Date 2017-08-01 and End Date 2017-10-30. I would like this event to become 3 separate records – one for 8/2017, one for 9/2017, and a third for 10/2017 (formatting not important).

I am not sure how to go about this. Any suggestions?

[danrh]

You can do this through the Generate Rows tool.  It allows you to loop through data and create rows until hitting a parameter you set --- in this case, the end date.

Hopefully this helps!

Dan

[DultonM · Accepted solution]

Hi @aiubxh8! Like @danrh said, the Generate Rows tool is perfect for this problem. I built out a slightly different solution that doesn't require a Formula tool.