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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
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

Highlighted
Atom

Thank you.

Labels