Date Filter Not Working In N Printing Report

[gopipnr]

I am trying to filter the date, but I am unable to do it. The same logic is working in the other report. Any suggestions are appreciated. thanks in Advance

[ajaykakkar93]

Hi,

I suggest you to create a copy of the same date column & convert it into the number format & then use the filter it will work

[Lech_Miszkiewicz]

Hi @gopipnr 

i on the other hand suggest to learn and educate yourself about data types in Qlik Sense and how they affect Nprinting filters. 
I have described all issues in below topics:

• https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
• https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/
• https://nprintingadventures.com/2022/03/19/filters-in-nprinting-how-hard-can-it-be-part-3-evaluate-v...

you dont need to create new columns but you need to understand  your data, be in control of its type and then apply suitable filter.

Lastly search community for similar topics instead of creating and repeating the same topic over again-here is example from last week: https://community.qlik.com/t5/Qlik-NPrinting/Filter-specific-date-dd-mm-rrrr-eg-22-10-2023/td-p/2130...

[gopipnr]

Thanks @ajaykakkar93 , But I have figured it out I have used

[Received_Date]>=date('10/01/2023') and [Received_Date]<=date('10/25/2023')

expression to solve the issues.