Filter data by date

[Pomna]

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

[Lech_Miszkiewicz]

Hi @Pomna ,

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.

More on that here:

https://nprintingadventures.com/2019/06/26/nprinting-filters-part-3-advanced-search/

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:

https://nprintingadventures.com/2019/02/15/the-pitfalls-of-nprinting-filters-part-1-dates-and-duals/