topic Re: How to convert pythons time.ctime() to a usable format in App Development https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45433#M3071 <HTML><HEAD></HEAD><BODY><P>Great! Thx!</P></BODY></HTML> Tue, 19 Jun 2018 07:26:58 GMT ghermann 2018-06-19T07:26:58Z How to convert pythons time.ctime() to a usable format https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45431#M3069 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have data with timestams in the python time.ctime() format.</P><P>Example: </P><P style="padding-left: 30px;">"Tue Jun 19 08:40:07 2018"</P><P>How can i "transform" this format in a usable date/time format? <SPAN lang="en"><SPAN>I would be very happy about helpful suggestions!</SPAN></SPAN></P><P><SPAN lang="en"><SPAN><span class="lia-unicode-emoji" title=":winking_face:">😉</span></SPAN></SPAN></P></BODY></HTML> Tue, 19 Jun 2018 06:50:24 GMT https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45431#M3069 ghermann 2018-06-19T06:50:24Z Re: How to convert pythons time.ctime() to a usable format https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45432#M3070 <HTML><HEAD></HEAD><BODY><P>If you have the date as a string like you show then this will work to interpret the string and convert it into a Qlik date:</P><P></P><P>=Date#( Mid( <EM>FieldOrVariableWithDate</EM> ,5,16 ) , 'MMM D hh:mm:ss YYYY' )</P></BODY></HTML> Tue, 19 Jun 2018 07:15:55 GMT https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45432#M3070 petter 2018-06-19T07:15:55Z Re: How to convert pythons time.ctime() to a usable format https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45433#M3071 <HTML><HEAD></HEAD><BODY><P>Great! Thx!</P></BODY></HTML> Tue, 19 Jun 2018 07:26:58 GMT https://community.qlik.com/t5/App-Development/How-to-convert-pythons-time-ctime-to-a-usable-format/m-p/45433#M3071 ghermann 2018-06-19T07:26:58Z