Based on Current Date get all previous months in current year

[SejalP1]

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 Date

10/01/2019

10/02/2019

10/03/2019

10/04/2019

10/05/2019

10/06/2019

10/07/2019

10/08/2019

Many Thanks.

[LukeM · Accepted solution]

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 solution]

hi 

Follows attached workflow

[CharlieS · Accepted solution]

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

[danilang · Accepted solution]

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