topic Re: Wrong dateformat in QlikView https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380625#M141995 <HTML><HEAD></HEAD><BODY><P>Date(right(DATEFIELD,2)&amp;'/'&amp;MID(DATEFIELD,5,2)&amp;'/'&amp;LEFT(DATEFIELD,4),'DD/MM/YYYY')</P></BODY></HTML> Fri, 24 Aug 2012 08:29:57 GMT 2012-08-24T08:29:57Z Wrong dateformat https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380624#M141994 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>I have some probelm with a field in my file. I have date and time in wrong format, 12/03/07 16:34:38. I will have this field in 20120307. i have try date and date#, but with wrong result. Some one who can help me?</P><P></P><P>Thanks!</P></BODY></HTML> Fri, 24 Aug 2012 08:06:05 GMT https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380624#M141994 2012-08-24T08:06:05Z Re: Wrong dateformat https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380625#M141995 <HTML><HEAD></HEAD><BODY><P>Date(right(DATEFIELD,2)&amp;'/'&amp;MID(DATEFIELD,5,2)&amp;'/'&amp;LEFT(DATEFIELD,4),'DD/MM/YYYY')</P></BODY></HTML> Fri, 24 Aug 2012 08:29:57 GMT https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380625#M141995 2012-08-24T08:29:57Z Re: Wrong dateformat https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380626#M141996 <HTML><HEAD></HEAD><BODY><P>Thanks!</P></BODY></HTML> Fri, 24 Aug 2012 08:42:54 GMT https://community.qlik.com/t5/QlikView/Wrong-dateformat/m-p/380626#M141996 2012-08-24T08:42:54Z