Splunk Search

evaluate if date field dd/mm is older than 5 working days.

alfiyashaikh
New Member

I have case such as :

if date is older than 5 working (eg if today is Thursday 19th, then anything older than Thursday 12th), update the Feedback column with ‘resolution needs chase’

I have field extacted and converted by this code :

|eval testTime = strptime('VTN_field_2',"%d/%m")
|eval testTime2=(strftime('testTime',"%d/%m"))

which gives epoch date testTime :
e.g
1512498600.000000
1512498600.000000

and testTime2
e.g
01/12
06/12

Tags (2)
0 Karma

harsmarvania57
Ultra Champion

I think this question is already answered here https://answers.splunk.com/answers/596221/convert-field-values-eg-1512-to-date-format-unders.html

Please let us know if this is different requirement.

0 Karma

DalJeanis
Legend

Use that one (as just updated) and reverse the test.

0 Karma

alfiyashaikh
New Member

It is the same question, no different requirement .
here just "5 working days" is specified.

0 Karma
Get Updates on the Splunk Community!

Splunk App for Anomaly Detection End of Life Announcment

Q: What is happening to the Splunk App for Anomaly Detection?A: Splunk is officially announcing the ...

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...