I have lookup file my_dates.csv like this:
mydate, something
1/1/2019, sth1
2/12/2019,sth2
2/20/2019,sth
3/13/2019,sth3
I need to perform a search for if today's date is not the one in my_dates.csv. My search looks like this:
|bin _time span=1d | search NOT [|inputlook my_dates.csv | eval _time=strptime(mydate, "%m%d%Y") | table _time]
However, this seems to not work. For example, today's date is 2/20/2019. I still got some results back if I run the above search.
... View more