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!
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!
Blame Americanism on this. In your user account, see if there is an option to customize locale, not just timezone.