Duplicate rows using date range

I have an interesting problem...I need to duplicate this row by the number of months between the start and end date. Each row needs to have the date it represents

Date Range Problem.JPG

For example, this row above would need to be duplicated 60 times with each row containing the YYYY-MM it represents.

I was thinking of doing a datediff on the dates to come up with the number of months. Then use a multi row tool to generate the additional rows and then use the datetimeadd (month) function against the start date to populate the YYYY-MM

Open to any other suggestions too!

Developer

Date Time

Transformation

Accepted answers

alexnajm

You should use the Generate Rows tool! It would accomplish this - I am away from my computer but the initialization would be the [Start Date], the condition would be where the [New Column] <= [End Date], and the loop expression would be DateTimeAdd([New Column],1,”days”)