community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

calculate subtraction between 2 date format

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                   ?

 

Alteryx Certified Partner

Hi @Tripathi

 

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

Quasar

Here is the solution for your case. 

 

workflow.PNGResults.PNG

Atom

Thank you.

Labels