https://community.splunk.com/t5/Splunk-Search/convert-the-date-in-required-format/m-p/188965#M54454 <P>Try this. Assuming your field name is date.</P> <PRE><CODE>your base search | eval date=strptime(date,"%e-%b-%y") | eval date=strftime(date,"%d-%b-%y") </CODE></PRE> Fri, 14 Mar 2014 17:09:53 GMT somesoni2 2014-03-14T17:09:53Z https://community.splunk.com/t5/Splunk-Search/convert-the-date-in-required-format/m-p/188964#M54453 <P>Hai i have a field which has dates</P> <P>example : 1-Oct-13<BR /> 4-Dec-13<BR /> 28-Oct-13</P> <P>I have to convert to below format</P> <P>01-Oct-13<BR /> 04-Oct-13 and so on....</P> <P>Please help me </P> <P>Thanking you in advance</P> Fri, 14 Mar 2014 17:04:58 GMT https://community.splunk.com/t5/Splunk-Search/convert-the-date-in-required-format/m-p/188964#M54453 ncbshiva 2014-03-14T17:04:58Z https://community.splunk.com/t5/Splunk-Search/convert-the-date-in-required-format/m-p/188965#M54454 <P>Try this. Assuming your field name is date.</P> <PRE><CODE>your base search | eval date=strptime(date,"%e-%b-%y") | eval date=strftime(date,"%d-%b-%y") </CODE></PRE> Fri, 14 Mar 2014 17:09:53 GMT https://community.splunk.com/t5/Splunk-Search/convert-the-date-in-required-format/m-p/188965#M54454 somesoni2 2014-03-14T17:09:53Z