Need to Find the Months Between Two Dates

[ashleyinman]

I have the data attached. 

I'm looking to find all the months between the created date and the delv date. 

Ex.

Order Created Date	Delv Date	Line Number	loc	Number	qty
3/30/2018	6/14/2018	1.1	10	10000	1

This is what I would like it to show. I do not want to show the month of the Delv Date. 

Order Created Date	Delv Date	Line Number	loc	Number	qty	Months Between
3/30/2018	6/14/2018	1.1	10	10000	1	Mar-18
3/30/2018	6/14/2018	1.1	10	10000	1	Apr-18
3/30/2018	6/14/2018	1.1	10	10000	1	May-18

I have tried using a generate rows tool but I keep getting the error "The value did not change after the Loop Expression"

Initialization Expression: [Order Created Date]

Condition Expression: [Order Created Date] < [Delv Date]

Loop Expression: DateTimeAdd([Order Created Date],1,'months')

[jdunkerley79 · Accepted solution]

I would suggest a generate rows tool creating a new Date field with formula:

Init: DateTimeTrim([Order Created Date],"firstofmonth")
Condition: [MonthsBetween] < DateTimeTrim([Delv Date],"firstofmonth")
Loop: DateTimeAdd([MonthsBetween],1,"months")

This will produce a column of 1st of the months. You can then use a DateTime tool to format as MMM-YY

Sample attached