In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities
here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started.
Learn more here
Alteryx Designer Desktop Discussions
Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED
Howdy you wonderful Alteryx community! I am going to conquer SQL one day - may not be for 10-years, but, it will occur.
Todays problem: I am trying to figure out the number of days between the first Tx Plan Final Approval Date and the next Tx Plan Final Approval Date. Notice, it's the same Column Header! So, I thought Rank - count the number of Tx Plan Final Approval Dates per case number. But, now I'm stuck... Here's a snip:
Ike that 7/13/2021 and the 7/15/2021 - 2 days, the next step will be to filter out everything less than 30 days. But, how do I write the SQL for this?
A Pre-Thank You to all you awesome folks for responding!
Solved! Go to Solution.
