How to Calculate Duration Between Two Dates?
There is a case that you want to know the duration between two dates like duration between a date column and a specific date or between two Date columns. So how do you do this in Exploratory?
For example, if you want to a calculate duration between a specific date (let's say
2017-03-01) and date column (let's say
Date Joined column)
You can calculate duration like below.
This will create a new column called
duration and you can get days out of it from column header menu like below.