topic Re: Date convert into DD/MM/YYY in QlikView https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41767#M788957 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Use this</SPAN></P><P></P><P>date(date#(DATE,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YYMMDD'),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DD/MM/YYYY</SPAN>')</SPAN></P></BODY></HTML> Sat, 17 Feb 2018 14:10:32 GMT shiveshsingh 2018-02-17T14:10:32Z Date convert into DD/MM/YYY https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41766#M788956 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>Can any one please help me on below requirement.</P><P>I have a DATE Field like YYMMDD below. How to convert this field like DD/MM/YYYY&nbsp; Please help me on this.</P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41766#M788956 bhavvibudagam 2020-11-25T16:16:04Z Re: Date convert into DD/MM/YYY https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41767#M788957 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Hi</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Use this</SPAN></P><P></P><P>date(date#(DATE,'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">YYMMDD'),'<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">DD/MM/YYYY</SPAN>')</SPAN></P></BODY></HTML> Sat, 17 Feb 2018 14:10:32 GMT https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41767#M788957 shiveshsingh 2018-02-17T14:10:32Z Re: Date convert into DD/MM/YYY https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41768#M788958 <HTML><HEAD></HEAD><BODY><P>Have a look at</P><P><A href="https://community.qlik.com/qlik-blogpost/2622">Get the Dates Right</A></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P><P></P><P>and also the referenced technical brief.</P></BODY></HTML> Sat, 17 Feb 2018 16:05:30 GMT https://community.qlik.com/t5/QlikView/Date-convert-into-DD-MM-YYY/m-p/41768#M788958 swuehl 2018-02-17T16:05:30Z