Calculating next date

[xman1968]

Hello,

I have a requirement based on the following data;

for each unit, I need to set the Next_date field as the next consecutive start_date less one day. For example, the next date for line 1 should be 19-Jan-2020, line 2 should be 14-Feb-2020. And since there are no further lines for unit 1 on line 3, the next date should be today. Is there a way to do this in Alteryx?

thanks,

Line	Unit	Customer	Start_date	End_date	Next_date	What next date should be
1	1	A	01-Jan-20	15-Jan   20		19-Jan-20
2	1	B	20-Jan-20	31-Jan-20		14-Feb-20
3	1	C	15-Feb-20	31-Mar-20		27-Apr-20
4	2	D	01-Jan-20	28-Feb-20		14-Mar-20
5	2	E	15-Mar-20	20-Mar-20		20-Mar-20
6	2	F	21-Mar-20	31-Mar-20		27-Apr-20

[JosephSerpis · Accepted solution]

Hi @xman1968 I mocked up a workflow let me know what you think?

[xman1968 · Accepted solution]

Thank you Joseph,

this worked perfectly for my requirements.

Regards