Hi vtsguerrero,
you can use strptime on the CAMPAIGN_COMPLETE_DATE like this:
... | eval Today = strftime(now(), "%d/%m/%Y %H:%M:%S") | eval searchTime = strptime(CAMPAIGN_COMPLETE_DATE, "%d/%m/%Y %H:%M:%S") | where searchTime = Today | ...
From the docs http://docs.splunk.com/Documentation/Splunk/6.2.4/SearchReference/CommonEvalFunctions about strptime
This function takes an epochtime value, X, as the first argument and renders it as a string using the format specified by Y.
Hope this helps ...
cheers, MuS
... View more