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!

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...

Auto-Injector for Everything Else: Making OpenTelemetry Truly Universal

You might have seen Splunk’s recent announcement about donating the OpenTelemetry Injector to the ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...