Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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