topic convert into Double + (String Date) into Double + String in QlikView https://community.qlik.com/t5/QlikView/convert-into-Double-String-Date-into-Double-String/m-p/1381480#M421060 <HTML><HEAD></HEAD><BODY><P>i have a field like below. how can i convert it into Double + String format.</P><P></P><P>field = hh:mm:ss</P><P></P><P></P><P>thx</P></BODY></HTML> Tue, 31 Oct 2017 01:42:39 GMT userid128223 2017-10-31T01:42:39Z convert into Double + (String Date) into Double + String https://community.qlik.com/t5/QlikView/convert-into-Double-String-Date-into-Double-String/m-p/1381480#M421060 <HTML><HEAD></HEAD><BODY><P>i have a field like below. how can i convert it into Double + String format.</P><P></P><P>field = hh:mm:ss</P><P></P><P></P><P>thx</P></BODY></HTML> Tue, 31 Oct 2017 01:42:39 GMT https://community.qlik.com/t5/QlikView/convert-into-Double-String-Date-into-Double-String/m-p/1381480#M421060 userid128223 2017-10-31T01:42:39Z Re: convert into Double + (String Date) into Double + String https://community.qlik.com/t5/QlikView/convert-into-Double-String-Date-into-Double-String/m-p/1381481#M421061 <HTML><HEAD></HEAD><BODY><P>Time(Time#(field, 'hh:mm:ss'))</P><P></P><P>This will create a Dual that will have both a numeric format (fraction of a day) and string display format. </P><P></P><P>-Rob</P></BODY></HTML> Tue, 31 Oct 2017 02:00:44 GMT https://community.qlik.com/t5/QlikView/convert-into-Double-String-Date-into-Double-String/m-p/1381481#M421061 rwunderlich 2017-10-31T02:00:44Z