filter of a range of date

[P_qlik]

Hi,

I have a field in this format yyyymm, I need to filter a range of date, for example I should  have something like this:

202101<field<202104, I tried with advance search but it doesn't work.

How can I do?

Thank you

[Lech_Miszkiewicz · Accepted solution]

Hi

This has been discussed many times and you have asked identical questions too - please dont duplicate posts

for the date range advanced search you need to use syntax like i described here:

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

Please use the Last 12 months example where you have =[field]>=(yoursearch)*[field]<=(yoursearch)