topic Re: Date filters in Qlik NPrinting

Date filters

SteveW2 — Thu, 01 Jun 2023 20:18:02 GMT

Hi,

I'm am trying to create a filter that returns transactions with a date range greater than the 01/04/2023. The below works in QlikSense but doesn't work in NPrinting for some reason, please can you advise what I am doing wrong?

Thnaks,

Steve

Re: Date filters

Lech_Miszkiewicz — Fri, 02 Jun 2023 02:46:11 GMT

Hi @SteveW2

covering the basics :

make sure you understand data type of your date field (although advanced search is more forgiving in this aspect):
- https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/
- https://nprintingadventures.com/2022/03/19/filters-in-nprinting-how-hard-can-it-be-part-3-evaluate-value/
once you do that try wrapping your search in brackets like:
- =([jobbookeddate]>=AddMonths(YearStart(Today()),-3))
have a look here: https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

You may as well try and write your expression by omitting [jobbookeddate] in search expressions :

>=AddMonths(YearStart(Today()),-3)

Re: Date filters

SteveW2 — Fri, 02 Jun 2023 11:49:05 GMT

Thanks for your help Lech, all very useful information!