Calculate Anniversary Dates

[Uthpala_K]

Hi Team,

I am trying to calculate each occurrence of an anniversary date between a start and an end date that has an annual anniversary date.

I used the Generate Rows tool, however, am not getting the correct dates as it doesn't generate the last row for me.

e.g. 1

Start Date - 2017-05-08

End Date - 2030-08-04

Annual Anniversary Date - 11/08 (i.e. first anniversary for this item will be on 2017-08-11)

e.g. 2

Start Date - 2016-09-19

End Date - 2031-09-18

Annual Anniversary Date - 10/08 (i.e. first anniversary for this item will be on 2016-10-08)

How do I arrive at the calculation table using Alteryx?

[atcodedog05]

Happy to help : ) @Uthpala_K 

Cheers and happy analysing : )