Used & Non used Inventories

I have a list of used inventories with campaign names and creation dates. I want to show the count of used and non-used inventories in a dashboard with a date filter (like last 30 days, last 3 months). I’ve written a query for the count, but the date filter doesn’t work for non-used inventories. The filter works fine for used inventories, but not for the non-used ones. How can I fix this?

Non Used Inventories query:

SELECT *

FROM "Inventories List"

WHERE "ID" NOT IN

(

SELECT "_id"

FROM "Used Inventories"

)