topic Date Format displaying incorrect when uploading CSV in Splunk Search

Date Format displaying incorrect when uploading CSV

Declan123 — Thu, 08 Aug 2024 19:14:18 GMT

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.

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)

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

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

Thank you!

Re: Date Format displaying incorrect when uploading CSV

yuanliu — Thu, 08 Aug 2024 19:40:16 GMT

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

Re: Date Format displaying incorrect when uploading CSV

isoutamo — Thu, 08 Aug 2024 19:44:43 GMT

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

Re: Date Format displaying incorrect when uploading CSV

Declan123 — Thu, 08 Aug 2024 19:59:36 GMT

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!