topic How to convert multiple date formats into single date format in single column in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203420#M60749 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I have to do like, in single column there dates in multiple format, so how i can do or achive easily.</P><P>1) suppose dates are like "mm/dd/yyyy" and "dd/mm/yyyy" .</P><P>2) "mm/dd/yyyy" is in date format and "dd/mm/yyyy" in text .</P><P>but values are there in template.</P><P>Regards,</P><P>Kumar.</P><P></P></BODY></HTML> Thu, 16 Sep 2010 09:09:54 GMT 2010-09-16T09:09:54Z How to convert multiple date formats into single date format in single column https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203420#M60749 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P>I have to do like, in single column there dates in multiple format, so how i can do or achive easily.</P><P>1) suppose dates are like "mm/dd/yyyy" and "dd/mm/yyyy" .</P><P>2) "mm/dd/yyyy" is in date format and "dd/mm/yyyy" in text .</P><P>but values are there in template.</P><P>Regards,</P><P>Kumar.</P><P></P></BODY></HTML> Thu, 16 Sep 2010 09:09:54 GMT https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203420#M60749 2010-09-16T09:09:54Z How to convert multiple date formats into single date format in single column https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203421#M60750 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>you can bring data into a single format while loading.... (using date function)</P><P>date(DATEFILDNAME,'DD/MM/YYYY') as DATE</P><P>Regards</P></BODY></HTML> Thu, 16 Sep 2010 09:33:12 GMT https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203421#M60750 2010-09-16T09:33:12Z How to convert multiple date formats into single date format in single column https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203422#M60751 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Thanks,</P><P></P><P>I Got the solution!...</P><P>Regards,</P><P>Kumar.</P></BODY></HTML> Thu, 16 Sep 2010 13:11:32 GMT https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203422#M60751 2010-09-16T13:11:32Z Re: How to convert multiple date formats into single date format in single column https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203423#M60752 <HTML><HEAD></HEAD><BODY><P>can u post the solution for dis </P></BODY></HTML> Wed, 06 Feb 2013 18:33:50 GMT https://community.qlik.com/t5/QlikView/How-to-convert-multiple-date-formats-into-single-date-format-in/m-p/203423#M60752 2013-02-06T18:33:50Z