Splunk Search

How to create a search for date compare to get the exact output?

renuka
Path Finder

renuka_0-1596532169866.png

I am trying on date compare but i am unable to get the exact output

The condition for Date Compare:

if(First_Date.before(Verifed_Date ) consider the value as 1,
else if(First_Date.equals(Verifed_Date ) consider the values as 0,
else consider the r value as 2;
if D2_ExecutionDate is null or empty mean verified should be null
Verified Condition is:

(Date Compare(Verifed_Date ,First_Date == 0 || Verifed_Date ,First_Date == 1)
&& (Verifed_Date ,Second_Date == 2 || Verifed_Date, Second_Date == 0))
get the verified values from PhaseMapping verified = R06.1

For reference i attached a screenshot..please help me with this

Thanks in advance

Renuka

Labels (1)
Tags (1)
0 Karma
1 Solution

thambisetty
SplunkTrust
SplunkTrust

For date comparison, you should first convert any date format to epoch. Then you can compare.

share complete raw event with field names. 

————————————
If this helps, give a like below.

View solution in original post

0 Karma

bowesmana
SplunkTrust
SplunkTrust

You are comparing strings by quoting the field names in the case statement. Remove the quotes then you will compare fields, not the string values, i.e.

| eval DateCompare=case(First_Date<verified_Date,1,...)

 Also make sure the OR and AND boolean operators are in CAPS, not lower case as in your screenshot.

 

0 Karma

thambisetty
SplunkTrust
SplunkTrust

For date comparison, you should first convert any date format to epoch. Then you can compare.

share complete raw event with field names. 

————————————
If this helps, give a like below.
0 Karma
Get Updates on the Splunk Community!

2024 Splunk Career Impact Survey | Earn a $20 gift card for participating!

Hear ye, hear ye! The time has come again for Splunk's annual Career Impact Survey!  We need your help by ...

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...