Splunk Search

Date Format displaying incorrect when uploading CSV

Declan123
Explorer

HI All,

I am new to using Splunk. 

I am uploading a CSV to Splunk that has a column called 'Transaction Date' with the entries in DD/MM/YYYY format as shown below.

Declan123_0-1723143130936.png

At the Set Source Type step I have updated the timestamp format to avoid getting the default modtime. I have updated it with %d/%m/%Y as shown below. This partly works as my '_time' field no longer shows the default modtime. However it shows the date in the incorrect format of MM/DD/YYYY instead of DD/MM/YYYY. (also shown below)

 

Declan123_1-1723143945718.png

 

Everything else I have left as default. These are my advanced settings:

Declan123_0-1723144245324.png

Any Ideas how I can fix this to display the correct format? 

Thank you!

Labels (1)
0 Karma
1 Solution

isoutamo
SplunkTrust
SplunkTrust
Or try to use some other locale than en-US on URL when you login to splunk.

View solution in original post

Declan123
Explorer

That worked, thank you both very much. I changed it to en-GB in the URL and it is now working as expected. 

Thank you!

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Blame Americanism on this.  In your user account, see if there is an option to customize locale, not just timezone.

isoutamo
SplunkTrust
SplunkTrust
Or try to use some other locale than en-US on URL when you login to splunk.
Get Updates on the Splunk Community!

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Your Voice Matters! Help Us Shape the New Splunk Lantern Experience

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Building Momentum: Splunk Developer Program at .conf25

At Splunk, developers are at the heart of innovation. That’s why this year at .conf25, we officially launched ...