topic Between Dates in QlikView https://community.qlik.com/t5/QlikView/Between-Dates/m-p/597840#M1107351 <HTML><HEAD></HEAD><BODY><P><BR />What is the best way to filter data between dates?</P><P></P><P>I am trying to count records where</P><P>Status&lt;&gt; Closed and Today is after Sched Date and Today is before Intended Completion Date.</P><P></P><P>Here is my Expression:</P><P></P><P>=<SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN>{&lt;<BR /><SPAN style="color: #800000;">[Internal Audits.Status]</SPAN>-={'Closed'},<BR /><SPAN style="color: #800000;">[Internal Audits.Sched Date]</SPAN>={<SPAN style="color: #800000;">"&lt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN>},<BR /><SPAN style="color: #800000;">[Internal Audits.Intended Completion Date]</SPAN>={<SPAN style="color: #800000;">"&gt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN>}</P><P></P><P>&gt;}<SPAN style="color: #800000;">[Internal Audits.Audit No]</SPAN>)</P><P></P><P>I run the report and I am not picking up one record where the status is Not Closed, the Sched Date is 3/1/2014 and the Intended Comp Date is 4/13/2014. </P><P></P><P>Is there an issue with my Expression? Is there a better way to filter between dates?</P><P></P><P>Jeff</P></BODY></HTML> Thu, 20 Mar 2014 00:35:38 GMT jmonroe918 2014-03-20T00:35:38Z Between Dates https://community.qlik.com/t5/QlikView/Between-Dates/m-p/597840#M1107351 <HTML><HEAD></HEAD><BODY><P><BR />What is the best way to filter data between dates?</P><P></P><P>I am trying to count records where</P><P>Status&lt;&gt; Closed and Today is after Sched Date and Today is before Intended Completion Date.</P><P></P><P>Here is my Expression:</P><P></P><P>=<SPAN style="color: #0000ff;">Count</SPAN>(<SPAN style="color: #0000ff;">DISTINCT</SPAN>{&lt;<BR /><SPAN style="color: #800000;">[Internal Audits.Status]</SPAN>-={'Closed'},<BR /><SPAN style="color: #800000;">[Internal Audits.Sched Date]</SPAN>={<SPAN style="color: #800000;">"&lt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN>},<BR /><SPAN style="color: #800000;">[Internal Audits.Intended Completion Date]</SPAN>={<SPAN style="color: #800000;">"&gt;=$(=Date(Today(),'MM/DD/YYYY'))"</SPAN>}</P><P></P><P>&gt;}<SPAN style="color: #800000;">[Internal Audits.Audit No]</SPAN>)</P><P></P><P>I run the report and I am not picking up one record where the status is Not Closed, the Sched Date is 3/1/2014 and the Intended Comp Date is 4/13/2014. </P><P></P><P>Is there an issue with my Expression? Is there a better way to filter between dates?</P><P></P><P>Jeff</P></BODY></HTML> Thu, 20 Mar 2014 00:35:38 GMT https://community.qlik.com/t5/QlikView/Between-Dates/m-p/597840#M1107351 jmonroe918 2014-03-20T00:35:38Z