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!

The OpenTelemetry Certified Associate (OTCA) Exam

What’s this OTCA exam? The Linux Foundation offers the OpenTelemetry Certified Associate (OTCA) credential to ...

From Manual to Agentic: Level Up Your SOC at Cisco Live

Welcome to the Era of the Agentic SOC   Are you tired of being a manual alert responder? The security ...

Splunk Classroom Chronicles: Training Tales and Testimonials (Episode 4)

Welcome back to Splunk Classroom Chronicles, our ongoing series where we shine a light on what really happens ...