Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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.
