Hi Srhode,
QuickBooks Desktop provides tons of great financial reports and inventory reports to help you analyze and stay on top of your business health. You also have the flexibility to customize these reports to focus on details that are most important to you. I'll be happy to share more on this.
The majority of reports in QuickBooks Desktop can be customized and sort out by date. The Physical Inventory Worksheet report, however, displays your information as of date. Given that you can't customize this report to present a specific date in the program, I encourage you to explore the option of exporting your report to excel and sort it out from there. I can see how having the option to customize this report by date in-product would have benefited your business and I invite you to submit feedback directly to our engineers by going through these steps: Help>Send Feedback Online>Product Suggestions. Your comments are crucial in driving innovation to offer the best QuickBooks experience we can.
Have a nice day!