Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

date diffrence

Faisalomran1
7 - Meteor

to ask in alteryx com..PNG

in the table each well api number has two or more dates. I want to calculate in and output in an new column the difference between the two dates in months of each API Number

2 REPLIES 2
TheOC
15 - Aurora
15 - Aurora

hi @Faisalomran1 

here is a workflow that achieves this!

TheOC_0-1603837223544.png



Please let me know if i can help in any other way.

This is done through the datetimediff formula tool

TheOC_1-1603837266344.png



Find attached the workflow 🙂 


Bulien
Qiu
20 - Arcturus
20 - Arcturus

@Faisalomran1 

I took a bit different approach.

Since there are cases that one well API Number having 3 dates, since I list them in an accending order then calcute the diffirence.

1028-Faisalomran1.PNG

Labels