topic Re: Converting this string into Date Time in QlikView https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397917#M700209 <HTML><HEAD></HEAD><BODY><P>Sorry.&nbsp; Correction.&nbsp; That would 10/24/2012 12:20</P></BODY></HTML> Fri, 02 Nov 2012 22:21:27 GMT 2012-11-02T22:21:27Z Converting this string into Date Time https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397916#M700207 <HTML><HEAD></HEAD><BODY><P>Hi everyone.&nbsp; First posting.</P><P></P><P>I am wanting to convert this string (or could be numeric) into a qliview date/time format.&nbsp; 0:201212412200000:0.000000:0:0</P><P>Want to look like 10/24/2012 12:00 or even qlikview's numeric value will be fine as well.</P><P></P><P>Thank you very much</P><P></P><P>Mark</P></BODY></HTML> Fri, 02 Nov 2012 22:18:52 GMT https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397916#M700207 2012-11-02T22:18:52Z Re: Converting this string into Date Time https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397917#M700209 <HTML><HEAD></HEAD><BODY><P>Sorry.&nbsp; Correction.&nbsp; That would 10/24/2012 12:20</P></BODY></HTML> Fri, 02 Nov 2012 22:21:27 GMT https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397917#M700209 2012-11-02T22:21:27Z Re: Converting this string into Date Time https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397918#M700210 <HTML><HEAD></HEAD><BODY><P>If you've missed a zero inbetween your string (<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">0:20121<STRONG>0</STRONG>2412200000:0.000000:0:0)</SPAN></P><P>I think you can do it like:</P><P></P><P>=Timestamp(Date#(mid('0:2012102412200000:0.000000:0:0',3,12),'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm')</P><P></P><P>resp.</P><P></P><P>=Timestamp(Date#(mid(YOURSTRINGFIELD,3,12),'YYYYMMDDhhmm'),'MM/DD/YYYY hh:mm')</P><P></P><P>Hope this helps,</P><P>Stefan</P></BODY></HTML> Fri, 02 Nov 2012 23:53:21 GMT https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397918#M700210 swuehl 2012-11-02T23:53:21Z Re: Converting this string into Date Time https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397919#M700211 <HTML><HEAD></HEAD><BODY><P>Thank you Stefan.&nbsp; That works great!</P></BODY></HTML> Sat, 03 Nov 2012 16:06:31 GMT https://community.qlik.com/t5/QlikView/Converting-this-string-into-Date-Time/m-p/397919#M700211 2012-11-03T16:06:31Z