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!

Your Guide to Splunk Digital Experience Monitoring

A flawless digital experience isn't just an advantage, it's key to customer loyalty and business success. But ...

Data Management Digest – November 2025

  Welcome to the inaugural edition of Data Management Digest! As your trusted partner in data innovation, the ...

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...