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