Splunk Search

How to convert DD/MM/YYY to MM/DD/YYY format?

Explorer

I currently have dates from a log file coming in as 09/07/2018 (July 9, 2018) and they need to be formatted as 07/09/2018.

0 Karma
1 Solution

Influencer

Convert it into a date type variable using strptime and then format it using stftime. Sample run anywhere search below.

|makeresults | eval DATE="09/07/2018" | eval DATE_NEW=strftime(strptime(DATE, "%d/%m/%Y"), "%m/%d/%Y")

View solution in original post

Influencer

Convert it into a date type variable using strptime and then format it using stftime. Sample run anywhere search below.

|makeresults | eval DATE="09/07/2018" | eval DATE_NEW=strftime(strptime(DATE, "%d/%m/%Y"), "%m/%d/%Y")

View solution in original post