The only way to compare dates is to first convert them in epoch (integer) form using the strptime function. The current time, returned by now(), is already in epoch form. Splunk accounts for time zone differences when converting to epoch. | eval first=strptime(first_time, "%Y-%m-%dT%H:%M:%S.%3N%Z"),
last=strptime(last_time, "%Y-%m-%dT%H:%M:%S.%3N%Z")
``` Compare each timestamp to see if they are today's date.
'relative_time(now(), "@d")' returns the timestamp for midnight (0:00) today. ```
| eval first_is_today = if(first > relative_time(now(), "@d"), 1, 0)
| eval last_is_today = if(last > relative_time(now(), "@d"), 1, 0)
... View more