Generate Months Using the generate rows function

Question

Hi There,

I am trying to generate rows in alteryx.

The date must be repeated every month for the next next 12 months

the date is October 31, 2019

so basically the next couple days should be

October 31st, 2019

November 30th 2019

December 31st 2019

January 31st, 2020

I am using the loop:

DateTimeAdd([Generated Month],1,'Month')

but it is giving me the following dates:

October 31st, 2019

November 30th 2019

December 30th 2019

January 30th, 2020

can you please help.

Thank you so much

Alteryx Photo.PNG

Shalz · Answer

once you generated these rows...you can use formula and get the last date of the month or whichever date you want for that month

apathetichell · Answer

logically that makes sense - and it works for the first month but

whereas for 10/31/2019

DateTimeAdd([Date],2,'months') is 12/31/2019

for 11/30/2019

DateTimeAdd([Date],1,'months') is 12/30/2019.

So if you generate integers and then datetimeadd them in a second column it'll totally work - but just datetimeadding them will start giving you the wrong dates after the first month.

Shalz · Answer

Start and End being your date ranges

Initialization Expression

[Start]

Condition Expression

[Date]<=[End]

Looping Expression

DateTimeAdd([Date],1,'months')