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
Solved! Go to Solution.
hi @Faisalomran1
here is a workflow that achieves this!
Please let me know if i can help in any other way.
This is done through the datetimediff formula tool
Find attached the workflow 🙂
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.