Date filters

[SteveW2]

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

[Lech_Miszkiewicz · Accepted solution]

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-v...
• 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)

[SteveW2 · Accepted solution]

Thanks for your help Lech, all very useful information!