Getting Data In

wrong event timestamp

SplunkCSIT
Communicator

After the data is forwarded to indexer, the date format for event seems to be incorrect for some events (whereby the day and month is less than 12) and correct for the rest (the day is more than 12), how come and what will be the remedy? The event timestamp is taken from the timestamp found inside the content of the data.

Correct timestamps:
02/03/2014
(dd/mm/yyyy)

14/03/2014
(dd/mm/yyyy)

incorrect timestamp:
02/03/2014
(mm/dd/yyyy)

Tags (1)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Specify a TIME_FORMAT in your props.conf to tell Splunk the order of month and day fields explicitly.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

Do post your config so we can take a look.

0 Karma

SplunkCSIT
Communicator

also the same, it happened for only two dates, 1Mar and 2Mar, it recognise as 3Jan, 3Feb, the rest of the dates, it able to get the correct date format.

0 Karma

linu1988
Champion

you need to set props.conf in indexer not forwarder..

0 Karma

SplunkCSIT
Communicator

already set that in forwarder props.conf but date format for event seems to be incorrect for some events (whereby the day and month is less than 12) and correct for the rest (the day is more than 12). Any other suggestion?

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Index This | What travels the world but is also stuck in place?

April 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data

Realizing the full potential of your Splunk investment requires more than just understanding current usage; it ...

Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...

As data volumes continue to grow and environments become more distributed, managing and optimizing data ...