Based on Current Date get all previous months in current year

Question

Hi,

Based on current date, would like to have all past months in current year.

For example

Input Date is:

Date 10/09/2019

Required Output:

Output Date10/01/201910/02/201910/03/201910/04/201910/05/201910/06/201910/07/201910/08/2019

Many Thanks.

LukeM · Accepted Answer

Hi @SejalP1 ,

You'll need the generate rows tool.

Please be mindful tat your dates need to be formatted correctly so Alteryx can work with them. For this you may need to use the DateTimeParse tool.

geraldo · Accepted Answer

hi

Follows attached workflow

CharlieS · Accepted Answer

I was able to achieve this using the Generate Rows tool. Check out the attached example to see this in action.

danilang · Accepted Answer

Hi @SejalP1

Similar to the solutions from @CharlieS , @geraldo  and @LukeM with difference being that the you don't need to enter the current date in an input box.  The generate rows uses DateTimeToday() as a starting value

Dan