https://community.qlik.com/t5/Qlik-NPrinting/Filter-data-by-date/m-p/1726666#M29427 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/59879">@Pomna</a>&nbsp;,</P><P>You are not using correct filter type. In place where you have "value is" there is a dropdown. Use it to toggle it to Advanced Search type.</P><P>More on that here:</P><P><A href="https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/" target="_blank">https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/</A></P><P>&nbsp;</P><P>Also very important - you are using functions MonthEnd etc.. those functions also return timestamp (instead of date) which is often another common pitfall of wrongly applied filters. More on this here:</P><P><A href="https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/" target="_blank">https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/</A></P><P>&nbsp;</P> Thu, 09 Jul 2020 23:37:56 GMT Lech_Miszkiewicz 2020-07-09T23:37:56Z https://community.qlik.com/t5/Qlik-NPrinting/Filter-data-by-date/m-p/1726658#M29425 <P>I need to create date filter in NPrinting to get only data for the last six months. Below is what I got but its not working. Thanks for your suggestions</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pomna_0-1594334675618.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/37258i28CD025904B0B8F0/image-size/medium?v=v2&amp;px=400" role="button" title="Pomna_0-1594334675618.png" alt="Pomna_0-1594334675618.png" /></span></P><P>&nbsp;</P> Thu, 09 Jul 2020 22:47:26 GMT https://community.qlik.com/t5/Qlik-NPrinting/Filter-data-by-date/m-p/1726658#M29425 Pomna 2020-07-09T22:47:26Z https://community.qlik.com/t5/Qlik-NPrinting/Filter-data-by-date/m-p/1726666#M29427 <P>Hi <a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/59879">@Pomna</a>&nbsp;,</P><P>You are not using correct filter type. In place where you have "value is" there is a dropdown. Use it to toggle it to Advanced Search type.</P><P>More on that here:</P><P><A href="https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/" target="_blank">https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/</A></P><P>&nbsp;</P><P>Also very important - you are using functions MonthEnd etc.. those functions also return timestamp (instead of date) which is often another common pitfall of wrongly applied filters. More on this here:</P><P><A href="https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/" target="_blank">https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/</A></P><P>&nbsp;</P> Thu, 09 Jul 2020 23:37:56 GMT https://community.qlik.com/t5/Qlik-NPrinting/Filter-data-by-date/m-p/1726666#M29427 Lech_Miszkiewicz 2020-07-09T23:37:56Z