Based on Current Date get all last four months in output

[SejalP1]

Hi, 

Based on current date, want last four months date in output.

For example:

Input Date is: 

Date

18/07/2019

required output:

Last four months date

18/07/2019

18/06/2019

18/05/2019

18/04/2019

Thank you! 

[LordNeilLord · Accepted solution]

Hey @SejalP1 

I'd personally go for Generate Rows (I love this tool)

You can get it calculate dates backwards until you hit 4 months ago from the date entered.

[andyuttley · Accepted solution]

hi @SejalP1 

Hopefully the attached gives you what you're after:

Let me know if not. 

Thanks

Andy 

[andyuttley · Accepted solution]

Looks like @LordNeilLord  beat me to it! 

[Thableaus · Accepted solution]

Hi @SejalP1 

You can use Generate Rows to do it:

WF attached.

Cheers,

[LordNeilLord]

@SejalP1 

3 awesome alteryx users have suggested exactly the same answer!! I think you have the "right" way to do it

@andyuttley @Thableaus Great job guys!!

[SejalP1]

Works Perfectly. Thank You!

[SejalP1]

Works Perfectly. Thank You!