topic Re: How to change date format in QlikView https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786169#M278117 <HTML><HEAD></HEAD><BODY><P>date(date#(Created_Date,'YYYYMMDD'),'DD/MM/YYYY') as Created_Date</P></BODY></HTML> Wed, 11 Feb 2015 12:57:16 GMT Gysbert_Wassenaar 2015-02-11T12:57:16Z How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786167#M278115 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I have a table in which date is in the format YYYYMMDD.</P><P>How can I change it to the form DD/MM/YYYY</P><P></P><P></P><P>Warehouse_Order:</P><TABLE><TBODY><TR><TD>CREATED_DATE</TD><TD>as</TD><TD>Created_Date</TD><TD><P>,</P></TD></TR></TBODY></TABLE><P>resident (some table which gets data from an extractor from SAP)</P><P></P><P></P><P>Please help.</P><P>Arjun Jain</P></BODY></HTML> Wed, 11 Feb 2015 12:54:48 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786167#M278115 2015-02-11T12:54:48Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786168#M278116 <HTML><HEAD></HEAD><BODY><P>Try with</P><P></P><P>Load</P><P>...</P><P>date(myDate, 'DD/MM/YYYY') as newDate</P><P>....</P><P></P><P>let me know</P></BODY></HTML> Wed, 11 Feb 2015 12:56:55 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786168#M278116 alexandros17 2015-02-11T12:56:55Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786169#M278117 <HTML><HEAD></HEAD><BODY><P>date(date#(Created_Date,'YYYYMMDD'),'DD/MM/YYYY') as Created_Date</P></BODY></HTML> Wed, 11 Feb 2015 12:57:16 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786169#M278117 Gysbert_Wassenaar 2015-02-11T12:57:16Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786170#M278118 <HTML><HEAD></HEAD><BODY><P>And if that doesn't produce the results you want, try</P><P></P><P>:</P><P>date(date#(CREATED_DATE, 'YYYYMMDD'),'DD/MM/YYYY') as Created_Date</P></BODY></HTML> Wed, 11 Feb 2015 13:01:51 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/786170#M278118 Peter_Cammaert 2015-02-11T13:01:51Z