I am using the splunk field: _time and subtracting my own time field: open_date from the time field. The goal is to get the difference between these two time stamps. For example, one entry in the _time field is: "2021-03-11 11:17:13" and one entry in the open_date field is: "2021-06-07T14:50:42". I am running the current query operations: | eval difference = abs(_time - strptime(open_date, "%Y-%m-%dT%H:%M:%S")) | eval difference = strftime(difference,"%Y-%m-%dT%H:%M:%S") When running this for the above example entries I get a difference output of "1970-03-29T20:10:19", which is obviously incorrect. What am I doing wrong and how can I get the correct difference between these two fields?
... View more