topic Re: Date conversions in QlikView https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12156#M790025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In your sample you have two formats with DMMYY (10116) and DDMMYY (120116). So for manage these différences you can use :</P><P></P><P>=if(len(Date_field)=5,Date(Date#(Date_field,'DMMYY'),'DD/MM/YYYY'),Date(Date#(Date_field,'DDMMYY'),'DD/MM/YYYY'))</P><P></P><P><IMG alt="" class="jive-image image-1" height="61" src="https://community.qlik.com/legacyfs/online/193202_pastedImage_0.png" style="width: 216px; height: 60.6638px;" width="216" /></P></BODY></HTML> Mon, 12 Feb 2018 23:06:34 GMT sergio0592 2018-02-12T23:06:34Z Date conversions https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12155#M790024 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>i have a date field in the format of DMMYY but i need to format it to DD/MM/YYYY, can anyone help please?</P><P>i have attached a sample</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12155#M790024 hopkinsc 2020-11-25T16:16:04Z Re: Date conversions https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12156#M790025 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In your sample you have two formats with DMMYY (10116) and DDMMYY (120116). So for manage these différences you can use :</P><P></P><P>=if(len(Date_field)=5,Date(Date#(Date_field,'DMMYY'),'DD/MM/YYYY'),Date(Date#(Date_field,'DDMMYY'),'DD/MM/YYYY'))</P><P></P><P><IMG alt="" class="jive-image image-1" height="61" src="https://community.qlik.com/legacyfs/online/193202_pastedImage_0.png" style="width: 216px; height: 60.6638px;" width="216" /></P></BODY></HTML> Mon, 12 Feb 2018 23:06:34 GMT https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12156#M790025 sergio0592 2018-02-12T23:06:34Z Re: Date conversions https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12157#M790026 <HTML><HEAD></HEAD><BODY><P>fantastic, thanks very much. </P></BODY></HTML> Mon, 12 Feb 2018 23:14:54 GMT https://community.qlik.com/t5/QlikView/Date-conversions/m-p/12157#M790026 hopkinsc 2018-02-12T23:14:54Z