Alteryx Designer Desktop Discussions

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

calculate subtraction between 2 date format

Tripathi
5 - Atom

Hi 

 

I have two fields in date format and I wanted to calculate in days but tried various options could not succeed as below.

 

Open Date.                                Close Date.                                 Days?

1/22/2016 10:12:00 AM .         2/24/2016 11:12:00 AM                   ?

 

3 REPLIES 3
haroon_sa
10 - Fireball

Hi @Tripathi

 

Take a look at my attached workflow. Hope it will help. Let me know if any queries.Days.PNG

ponraj
13 - Pulsar

Here is the solution for your case. 

 

workflow.PNGResults.PNG

Tripathi
5 - Atom

Thank you.

Labels