https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463786#M191532 <P>@kavyamohan</P> <P>Can you please try this?</P> <PRE><CODE>| makeresults | eval jdate="19283",epoch_date=strptime(jdate,"%y%j"),date=strftime(epoch_date,"%d/%m/%Y") | table jdate date </CODE></PRE> Mon, 21 Oct 2019 07:06:40 GMT kamlesh_vaghela 2019-10-21T07:06:40Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463783#M191529 <P>SVSCPLEX,S0W1,S0W1.DAL-EBIS.IHOST.COM,SYSLOG,zOS-SYSLOG-Console,SYSLOG,-0400,NE,001C,19283 01.21.46.880 -0500,S0W1 ,JOB03487, ,40000000000000000000000000000000,00000090,TESCREAT,00," IEF450I TESCREAT STEP010 - ABEND=S222 U0000 REASON=00000000"\n. </P> <P>where, 19283 is julian date. I need to convert this to dd/mm/Y Is that possible?</P> Mon, 21 Oct 2019 06:21:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463783#M191529 kavyamohan 2019-10-21T06:21:23Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463784#M191530 <P>@kavyamohan </P> <P>Need more clarity:</P> <P>As per the <A href="http://www.longpelaexpertise.com/toolsJulian.php">http://www.longpelaexpertise.com/toolsJulian.php</A> .</P> <P><CODE>Julian Date: 19283</CODE><BR /> which is <CODE>Date: 10-Oct-2019</CODE>. It is giving the only date not <STRONG>%H:%M:%S</STRONG> . Can you please let us know your expected output ?? </P> Mon, 21 Oct 2019 06:45:06 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463784#M191530 kamlesh_vaghela 2019-10-21T06:45:06Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463785#M191531 <P>Sorry. It was my mistake. I need Julian Date: 19283 to this format 10/10/2019</P> Mon, 21 Oct 2019 07:01:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463785#M191531 kavyamohan 2019-10-21T07:01:22Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463786#M191532 <P>@kavyamohan</P> <P>Can you please try this?</P> <PRE><CODE>| makeresults | eval jdate="19283",epoch_date=strptime(jdate,"%y%j"),date=strftime(epoch_date,"%d/%m/%Y") | table jdate date </CODE></PRE> Mon, 21 Oct 2019 07:06:40 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463786#M191532 kamlesh_vaghela 2019-10-21T07:06:40Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463787#M191533 <P>It would be really helpful for others if you update the question. <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P> Mon, 21 Oct 2019 07:07:23 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463787#M191533 kamlesh_vaghela 2019-10-21T07:07:23Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463788#M191534 <P>Thanks, it worked</P> Mon, 21 Oct 2019 07:21:27 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463788#M191534 kavyamohan 2019-10-21T07:21:27Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463789#M191535 <P>Glad to help you.</P> <P><STRONG>Happy Splunking</STRONG></P> Mon, 21 Oct 2019 07:25:24 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463789#M191535 kamlesh_vaghela 2019-10-21T07:25:24Z https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463790#M191536 <P>yes i have updated question</P> Mon, 21 Oct 2019 09:22:38 GMT https://community.splunk.com/t5/Splunk-Search/How-to-convert-julian-date-to-dd-mm-Y/m-p/463790#M191536 kavyamohan 2019-10-21T09:22:38Z