Splunk Search

All fields from a lookup.csv file appear except the date field?

boris
Path Finder

All fields from a lookup.csv file appear as available search fields except the date field.

Here is how I defined the start_date field in my lookup.csv file:

'2012-03-12 20:10'

%Y-%m-%d %H:%M

So how can I get this start_date field to appear as a potential field in my searching here?

0 Karma
1 Solution

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

View solution in original post

0 Karma

boris
Path Finder

After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

boris
Path Finder

Thanks MarioM. After looking at the raw .csv of the lookup file I see the dates were formatted differently then I expected.

0 Karma

MarioM
Motivator

can you post an extract of your lookup.csv with the header?

Get Updates on the Splunk Community!

Webinar Recap | Revolutionizing IT Operations: The Transformative Power of AI and ML ...

The Transformative Power of AI and ML in Enhancing Observability   In the realm of IT operations, the ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...