If you'd like to see which items are 'In Use' within a custom date range all you have to do is navigate to the Inventory tab and put in the dates you'd like to search by clicking on the downward-facing arrow to the right of the 'Next 30 Days' text.
Once you've set a date range, add the following Custom Columns:
In Stock (how many you have ready to go in this range)
Quantity Booked (how many are added to signed contracts in this range)
Max Needed (the highest amount needed on all projects in this range, regardless of contract status)
Add more columns to find out which items are Booked, Gross Revenue, and more! Learn more here.