topic Time Field in QlikView https://community.qlik.com/t5/QlikView/Time-Field/m-p/318103#M117241 <HTML><HEAD></HEAD><BODY><P>I want to format a date field as it is being outputted as a string eg - 20112112</P><P></P><P>I need this to be&nbsp; 21-12-2011</P><P></P><P>Ive tried date(DoB,'dd-mm-yyyy') as DoB&nbsp;&nbsp; - this is outputting strings like '01-00-55345'</P><P></P><P>Ive also tried to split out the string using mid, left, right and then concatenating, this doesnt work either</P></BODY></HTML> Wed, 21 Dec 2011 17:18:54 GMT 2011-12-21T17:18:54Z Time Field https://community.qlik.com/t5/QlikView/Time-Field/m-p/318103#M117241 <HTML><HEAD></HEAD><BODY><P>I want to format a date field as it is being outputted as a string eg - 20112112</P><P></P><P>I need this to be&nbsp; 21-12-2011</P><P></P><P>Ive tried date(DoB,'dd-mm-yyyy') as DoB&nbsp;&nbsp; - this is outputting strings like '01-00-55345'</P><P></P><P>Ive also tried to split out the string using mid, left, right and then concatenating, this doesnt work either</P></BODY></HTML> Wed, 21 Dec 2011 17:18:54 GMT https://community.qlik.com/t5/QlikView/Time-Field/m-p/318103#M117241 2011-12-21T17:18:54Z Re: Time Field https://community.qlik.com/t5/QlikView/Time-Field/m-p/318104#M117242 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: courier new,courier;">date(date#(DoB,'YYYYDDMM'),'DD-MM-YYYY') as DoB</SPAN></P><P></P><P>Date() is just a formatting function.&nbsp; <EM><STRONG>D</STRONG><STRONG>ate#()</STRONG></EM> is how you read data from input to create a date field.&nbsp; Used together like the above, one must use the format of the input, and the other the format of the desired output.</P></BODY></HTML> Wed, 21 Dec 2011 17:29:27 GMT https://community.qlik.com/t5/QlikView/Time-Field/m-p/318104#M117242 johnw 2011-12-21T17:29:27Z