I have a dataset with two date column, ‘start_date’ and ‘end_date’. Is there a way to easily create
a ‘duration (days)’ column?
Use DateDifferenceWithColumn
function. For your particular case, execute the following command from the console (View | Console):
DateDifferenceWithColumn("table_name", "start_date", "end_date", "duration (days)", "days")
Please note that the last parameter - units
can take the following values: years | months | weeks | days | hours | minutes | seconds | milliseconds