topic Re: Nedd Suggestion in QlikView https://community.qlik.com/t5/QlikView/Nedd-Suggestion/m-p/1278978#M863778 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Date(Date#(Num(DateField, '##'), 'YYYYMMDD'), 'DD/MM/YYYY') as DateField</STRONG></P></BODY></HTML> Mon, 19 Dec 2016 15:42:42 GMT sunny_talwar 2016-12-19T15:42:42Z Nedd Suggestion https://community.qlik.com/t5/QlikView/Nedd-Suggestion/m-p/1278977#M863777 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt;">Hi All,</SPAN></P><P>When extract from csv file , I find the date format like 20,151,101 .How can I correct this format to like 20151101 or 01/11/2015.</P><P></P><P>Thanks,</P><P>Manoj.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Nedd-Suggestion/m-p/1278977#M863777 2020-11-25T16:16:04Z Re: Nedd Suggestion https://community.qlik.com/t5/QlikView/Nedd-Suggestion/m-p/1278978#M863778 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>Date(Date#(Num(DateField, '##'), 'YYYYMMDD'), 'DD/MM/YYYY') as DateField</STRONG></P></BODY></HTML> Mon, 19 Dec 2016 15:42:42 GMT https://community.qlik.com/t5/QlikView/Nedd-Suggestion/m-p/1278978#M863778 sunny_talwar 2016-12-19T15:42:42Z