https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363072#M107255 <P>Hello,</P> <P>I am trying to convert a field value which contains a number in timeformat YYYYMMDD to DD.MM.YYYY</P> <P>I tried several converting methods but it always end up with a whacky date, not the one that I require.</P> <P>Can anyone help me out?</P> Fri, 11 Aug 2017 13:21:17 GMT ckunath 2017-08-11T13:21:17Z https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363072#M107255 <P>Hello,</P> <P>I am trying to convert a field value which contains a number in timeformat YYYYMMDD to DD.MM.YYYY</P> <P>I tried several converting methods but it always end up with a whacky date, not the one that I require.</P> <P>Can anyone help me out?</P> Fri, 11 Aug 2017 13:21:17 GMT https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363072#M107255 ckunath 2017-08-11T13:21:17Z https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363073#M107256 <P>This should do the job.</P> <PRE><CODE>... | eval bar=strftime(strptime(foo, "%Y%m%d"),"%d.%m.%Y") | ... </CODE></PRE> Fri, 11 Aug 2017 13:48:47 GMT https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363073#M107256 richgalloway 2017-08-11T13:48:47Z https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363074#M107257 <P>Thanks alot!</P> Fri, 11 Aug 2017 13:51:14 GMT https://community.splunk.com/t5/Splunk-Search/Convert-YYYYMMDD-number-to-DD-MM-YYYY-format/m-p/363074#M107257 ckunath 2017-08-11T13:51:14Z