Calculating duration between dates in a CSV file and the present date

I am reading data from csv file which has a column that has date in the format like 5 Jun 2021. I want to calculate the duration between each date and present date. How can I do this?

Answer 1

[Samay Sagar]

You can use the between function to calculate duration between 2 dates. You can iterate over each value in column and apply the following operation :

currentDate = datetime('now');

givenDate = datetime('5-Jun-2021');


duration = between(givenDate,currentDate)

duration = calendarDuration
   2y 9d 16h 24m 6.8842s