date diffrence

[Faisalomran1]

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

[TheOC · Accepted 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 🙂 

[Qiu · Accepted solution]

@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.