Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
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?
Solved! Go to Solution.
