topic Date Format in App Development https://community.qlik.com/t5/App-Development/Date-Format/m-p/798819#M11122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new on this and I have made an app based on a excel file.</P><P></P><P>On that excel file I have a field with values like "01-Apr-2014". This is a date. However, the Qlik does not recognize it as a date and I need to make a order by this field.</P><P></P><P>Thanks for your help,</P><P>&nbsp;&nbsp; António Trindade</P></BODY></HTML> Thu, 26 Feb 2015 19:34:44 GMT ajvctrindade 2015-02-26T19:34:44Z Date Format https://community.qlik.com/t5/App-Development/Date-Format/m-p/798819#M11122 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm new on this and I have made an app based on a excel file.</P><P></P><P>On that excel file I have a field with values like "01-Apr-2014". This is a date. However, the Qlik does not recognize it as a date and I need to make a order by this field.</P><P></P><P>Thanks for your help,</P><P>&nbsp;&nbsp; António Trindade</P></BODY></HTML> Thu, 26 Feb 2015 19:34:44 GMT https://community.qlik.com/t5/App-Development/Date-Format/m-p/798819#M11122 ajvctrindade 2015-02-26T19:34:44Z Re: Date Format https://community.qlik.com/t5/App-Development/Date-Format/m-p/798820#M11123 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I investigate a little further and found this document.</P><P><A _jive_internal="true" href="https://community.qlik.com/docs/DOC-3102">http://community.qlik.com/docs/DOC-3102</A></P><P></P><P>I tried <STRONG>date(date#([<EM>«FIELD_NAME»</EM>],'DD-MMM-YYYY'))</STRONG> and it seems to work.</P><P></P><P>Thanks anyway,</P><P>&nbsp;&nbsp;&nbsp; António Trindade</P></BODY></HTML> Thu, 26 Feb 2015 19:54:37 GMT https://community.qlik.com/t5/App-Development/Date-Format/m-p/798820#M11123 ajvctrindade 2015-02-26T19:54:37Z