@gcusello , Tried this Search not giving the desire result | eval from_epoch = strptime(from, "%m/%d/%Y %I:%M %p") | eval till_epoch = strptime(till, "%m/%d/%Y %I:%M %p") | eval diff_seconds = till_epoch - from_epoch | eval diff_years = floor(diff_seconds / (365.25*24*60*60)) | eval remaining_seconds = diff_seconds - (diff_years * 365.25*24*60*60) | eval diff_days = floor(remaining_seconds / (24*60*60)) | eval remaining_seconds = remaining_seconds - (diff_days * 24*60*60) | eval diff_hours = floor(remaining_seconds / (60*60)) | eval diff_minutes = floor((remaining_seconds - (diff_hours * 60*60)) / 60) | eval duration = diff_years . " year" . if(diff_years != 1, "s", "") . " " . diff_days . " day" . if(diff_days != 1, "s", "") . " " . diff_hours . " hour" . if(diff_hours != 1, "s", "") . " " . diff_minutes . " min" output: 11/28/2023 05:10 PM 11/28/2024 05:40 PM 1 year 0 days 18 hours 30 min
... View more