topic Re: How can I convert string of numbers to date format? in Splunk Search https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280737#M84723 <P>Try like this</P> <PRE><CODE>your current search giving a field say "MyDate" | eval MyDateEpoch=strptime(MyDate,"%Y%m%d") | sort 0 MyDateEpoch </CODE></PRE> Tue, 07 Feb 2017 15:54:42 GMT somesoni2 2017-02-07T15:54:42Z How can I convert string of numbers to date format? https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280736#M84722 <P>I have a list of dates like below:</P> <P>20170201<BR /> 20171201<BR /> 20171225</P> <P>How can I convert this into a time value that i can sort oldest to youngest?</P> Tue, 07 Feb 2017 15:47:16 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280736#M84722 smcdonald20 2017-02-07T15:47:16Z Re: How can I convert string of numbers to date format? https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280737#M84723 <P>Try like this</P> <PRE><CODE>your current search giving a field say "MyDate" | eval MyDateEpoch=strptime(MyDate,"%Y%m%d") | sort 0 MyDateEpoch </CODE></PRE> Tue, 07 Feb 2017 15:54:42 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280737#M84723 somesoni2 2017-02-07T15:54:42Z Re: How can I convert string of numbers to date format? https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280738#M84724 <P>Thank you this worked!!</P> Tue, 07 Feb 2017 16:03:18 GMT https://community.splunk.com/t5/Splunk-Search/How-can-I-convert-string-of-numbers-to-date-format/m-p/280738#M84724 smcdonald20 2017-02-07T16:03:18Z