topic Select Date in Range in QlikView https://community.qlik.com/t5/QlikView/Select-Date-in-Range/m-p/298816#M1194429 <HTML><HEAD></HEAD><BODY><P>Good morning to all,</P><P></P><P>I have a lot of data in my Data Base, but I just need select a part of it, betwen date (E: betwen 01/01/2009 to 31/12/2011)</P><P>see below my scrip</P><P></P><P>SQL select*</P><P>from baan.ttdsls824804</P><P></P><P>Could help me please.</P><P></P></BODY></HTML> Fri, 17 Jun 2011 13:33:11 GMT 2011-06-17T13:33:11Z Select Date in Range https://community.qlik.com/t5/QlikView/Select-Date-in-Range/m-p/298816#M1194429 <HTML><HEAD></HEAD><BODY><P>Good morning to all,</P><P></P><P>I have a lot of data in my Data Base, but I just need select a part of it, betwen date (E: betwen 01/01/2009 to 31/12/2011)</P><P>see below my scrip</P><P></P><P>SQL select*</P><P>from baan.ttdsls824804</P><P></P><P>Could help me please.</P><P></P></BODY></HTML> Fri, 17 Jun 2011 13:33:11 GMT https://community.qlik.com/t5/QlikView/Select-Date-in-Range/m-p/298816#M1194429 2011-06-17T13:33:11Z Select Date in Range https://community.qlik.com/t5/QlikView/Select-Date-in-Range/m-p/298817#M1194430 <HTML><HEAD></HEAD><BODY><P>select*</P><P>from baan.ttdsls824804 where to_char(TO_DATE('01-01-2009', 'MM-DD-YYYY'),'YYYY')&gt;=2009</P><P>and to_char(TO_DATE('31-12-2011', 'MM-DD-YYYY'),'YYYY')&lt;=20011</P></BODY></HTML> Fri, 17 Jun 2011 16:44:15 GMT https://community.qlik.com/t5/QlikView/Select-Date-in-Range/m-p/298817#M1194430 2011-06-17T16:44:15Z