hi,
I uploaded csv file having a date field. This field has current week dates as well as future week dates.
CSV got uploaded successfully without any warning, but while searching on the csv it shows '0 events before 6/14/2017 8:51:00AM'. '6/14/2017 8:51:00AM' is current time.
I alreadyset MAX_DAYS_HENCE=30 in props.config
While uploading
On searching
You can do a search for All time
or, as @BlueSocket said, use latest=+30d
or similar.
I see what is going wrong - you have given the data in the future and so the data is indexed in the future. However, the search is by default in the past. Have you tried using the search:
source="New_Excel_B.csv" host="397AD-1A210036" sourcetype="csv" latest=+30d
now the result is "0 events (before 7/15/17 12:01:38.000 AM)"
I just had a thought., What happens when you do the following query?
sourcetype="csv" earliest=-10y latest=+10y
Do you get anything then?
One thing I noticed that it is showing count as '1' in Data Summary for 'New_Excel_B.csv' but while uploading it displayed all events the csv has. !!!