topic Re: How to change date format in QlikView https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493400#M1129409 <HTML><HEAD></HEAD><BODY><P>Thanks and it's working.</P></BODY></HTML> Tue, 26 Nov 2013 14:21:36 GMT 2013-11-26T14:21:36Z How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493398#M1129407 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I have data format in SQL table as 15/10/2013. so when I am loading data it is taking in the same way in qlikview chart.</P><P></P><P>Is it possible to show date as 15 Oct 2013?</P><P></P><P>Please can anyone let me know.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 26 Nov 2013 14:11:33 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493398#M1129407 2013-11-26T14:11:33Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493399#M1129408 <HTML><HEAD></HEAD><BODY><P>Date(Yourdate, 'DD MMM YYYY') should do it</P></BODY></HTML> Tue, 26 Nov 2013 14:15:08 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493399#M1129408 jerem1234 2013-11-26T14:15:08Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493400#M1129409 <HTML><HEAD></HEAD><BODY><P>Thanks and it's working.</P></BODY></HTML> Tue, 26 Nov 2013 14:21:36 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493400#M1129409 2013-11-26T14:21:36Z Re: How to change date format https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493401#M1129410 <HTML><HEAD></HEAD><BODY><P>Create new Field as mentioned below:</P><P></P><P>Load</P><P>Date(DateField,'DD-MMM-YYYY') as DATE;</P><P>Select * From DatabaseTableName;</P><P></P><P></P><P>Hope this will help you.</P><P></P><P>-Nilesh</P></BODY></HTML> Tue, 26 Nov 2013 14:23:04 GMT https://community.qlik.com/t5/QlikView/How-to-change-date-format/m-p/493401#M1129410 nilesh_gangurde 2013-11-26T14:23:04Z