community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Based on Current Date get all last four months in output

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! 

Alteryx Certified Partner

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

 

 

Bolide

hi @SejalP1 

 

Hopefully the attached gives you what you're after:

generatedates.PNG

 

 

Let me know if not. 

Thanks

Andy 

Highlighted
Bolide

Looks like @LordNeilLord  beat me to it! 

Alteryx Certified Partner
Alteryx Certified Partner

Hi @SejalP1 

 

You can use Generate Rows to do it:

 

GenerateRows.PNG

 

WF attached.


Cheers,

Alteryx Certified Partner

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

Meteor

Works Perfectly. Thank You!

Meteor

Works Perfectly. Thank You!

Labels