Alteryx Designer Desktop Discussions

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

Calculated Date Expression

valeriemattas
8 - Asteroid

Greetings --

 

Needing help with a workflow. We want to use a cutoff date to determine which month a transaction's approval should be. For example, if the transaction is posted prior to the 6th of the month, the approval must be by the 25th, else the approval must be by the 25th of the month after the post date month.

 

In order to compare the expected approval date to the actual, I need to write an expression to calculate the expected. Help!

 

Thanks so much,

 

Valerie 

5 REPLIES 5
pedrodrfaria
13 - Pulsar

Hi @valeriemattas 

 

Please see the workflow attached. Here we are first creating a logic to see what day of the month it is to then apply the cutoff logic to it.

 

pedrodrfaria_0-1609285308965.png

 

Pedro.

Qiu
20 - Arcturus
20 - Arcturus

@valeriemattas 

If I understand your intention correctly, this should be it.

1230-valeriemattas.PNG

Hi @valeriemattas 

 

Feel free to let me know if the below helps. Cheers!

 

christine_assaad_0-1609285602005.png

 

valeriemattas
8 - Asteroid

Perfect! Thanks @christine_assaad for helping get it done in one expression.

Qiu
20 - Arcturus
20 - Arcturus

@valeriemattas 

Appreciate if you wold give us the accept mark if it helps. 😁

Labels