Based on Current Date get all last four months in output

Question

Hi,

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

For example:

Input Date is:

Date18/07/2019

required output:

Last four months date18/07/201918/06/201918/05/201918/04/2019

Thank you!

LordNeilLord · Accepted Answer

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 Answer

hi @SejalP1

Hopefully the attached gives you what you're after:

Let me know if not.

Thanks

Andy

andyuttley · Accepted Answer

Looks like @LordNeilLord  beat me to it!

Thableaus · Accepted Answer

Hi @SejalP1

You can use Generate Rows to do it:

WF attached.

Cheers,