I have a log that has
Start date=2003-11-20 00:00:00,End date=2079-06-06 00:00:00.
I want to calculate the difference between the Enddate and Startdate, and display the difference in both days and in years.
Please help me
For days you can do this:
... | eval days = round((strptime(Enddate, "%F %T") - strptime(Startdate, "%F %T")) / 86400)
For years it depends on what you want to see.