topic Days Between Question in Splunk Search

Days Between Question

jhayIV — Wed, 05 Apr 2017 20:38:46 GMT

I am trying to determine the days between a static date and current date

in this query I added a the 2008r2 column with a static date - table Division Name OS _time | eval 2008r2="1/14/2020"|

I was unable to use a previous eval statement on this, I assume I dont have that column formatted properly
eval Days=round((2008r2(now(),"@d")-relative_time(2008r2,"@d"))/86400,0)

Re: Days Between Question

woodcock — Wed, 05 Apr 2017 20:55:15 GMT

We need to see sample event data and your full search.

Re: Days Between Question

somesoni2 — Wed, 05 Apr 2017 21:15:02 GMT

Use like this

...table Division Name OS _time | eval 2008r2="1/14/2020"| eval Days=round((relative_time(now(),"@d")-relative_time(strptime('2008r2',"%m/%d/%Y"),"@d"))/86400,0)

Basically, you need to convert your string date to epoch format so that you can do mathematical operation with current time now() which is in epoch. (the relative_time function also only accepts epoch value).