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!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...