Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Based on Current Date get all last four months in output

SejalP1
7 - Meteor

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! 

7 REPLIES 7
LordNeilLord
15 - Aurora

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.

 

Capture.PNG

 

 

andyuttley
11 - Bolide
11 - Bolide

hi @SejalP1 

 

Hopefully the attached gives you what you're after:

generatedates.PNG

 

 

Let me know if not. 

Thanks

Andy 

andyuttley
11 - Bolide
11 - Bolide

Looks like @LordNeilLord  beat me to it! 

Thableaus
17 - Castor
17 - Castor

Hi @SejalP1 

 

You can use Generate Rows to do it:

 

GenerateRows.PNG

 

WF attached.


Cheers,

LordNeilLord
15 - Aurora

@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
7 - Meteor

Works Perfectly. Thank You!

SejalP1
7 - Meteor

Works Perfectly. Thank You!

Labels