ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions.
Learn more 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.
