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.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

IF Replace Date formula - HELP!

MaryCann
8 - Asteroid

Hi all...  Okay, so, I have, let's say a Client ID column, a Treatment Plan Date column and a Treatment Plan Final Approval Date column.  I'm trying to write a formula where if the first Treatment Plan Final Approval Date is < = 1 compared to the next Treatment Plan Date then to replace the first Treatment Plan Final Approval Date with the second Treatment Plan Final Approval Date.  Here's where I am thus far:

MaryCann_0-1686682069177.png

 

2 REPLIES 2
nagakavyasri
12 - Quasar

Check if this meets your requirement:

 

Screenshot 2023-06-13 150324.png

MaryCann
8 - Asteroid

It looks like, with a little tweaking, I can get this to work!  Thank you!

Labels
Top Solution Authors