Alteryx Designer Desktop Discussions

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

Multi-Row Formulas and Generate Rows - Help with date Gaps in days

Mina2021
8 - Asteroid

Hi Everyone,

 

I am building a workflow where I needing the date difference in days creating a new column "difference"

Say example, 03/27/2019 and 01/20/2019 and the difference will be = 66 days

 

This need to be done in multirow formula.

Kindly help!

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@Mina2021 
Something like this?

Capture2C.PNG

Mina2021
8 - Asteroid

Hi,

 

If the minus values are not considered then?

Qiu
21 - Polaris
21 - Polaris

@Mina2021 

Not considered meaning set to 0?

Mina2021
8 - Asteroid

 

 

alpha_123_0-1616142632856.png

kindly help! 

I am attaching the workflow.

 

Labels