topic Re: Qlikview Time format JD Edwards in QlikView https://community.qlik.com/t5/QlikView/Qlikview-Time-format-JD-Edwards/m-p/124025#M765001 <HTML><HEAD></HEAD><BODY><P>Try&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; time(time#(num([Time Released], '000000'), 'hhmmss'))</P></BODY></HTML> Wed, 25 Jul 2018 16:44:47 GMT Colin-Albert 2018-07-25T16:44:47Z Qlikview Time format JD Edwards https://community.qlik.com/t5/QlikView/Qlikview-Time-format-JD-Edwards/m-p/124024#M765000 <HTML><HEAD></HEAD><BODY><P>Good Day </P><P>Can someone advise me how i can get the following time in the correct format? I have tried a few thing but cant seem to get around it?</P><P>Note that some of the times below has also eliminated the 0 in front. example 93240 should have been 093240 which is 09:32:40 .</P><P>Thanks</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/208800_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Qlikview-Time-format-JD-Edwards/m-p/124024#M765000 shalensookdeo 2020-11-25T16:16:04Z Re: Qlikview Time format JD Edwards https://community.qlik.com/t5/QlikView/Qlikview-Time-format-JD-Edwards/m-p/124025#M765001 <HTML><HEAD></HEAD><BODY><P>Try&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; time(time#(num([Time Released], '000000'), 'hhmmss'))</P></BODY></HTML> Wed, 25 Jul 2018 16:44:47 GMT https://community.qlik.com/t5/QlikView/Qlikview-Time-format-JD-Edwards/m-p/124025#M765001 Colin-Albert 2018-07-25T16:44:47Z