Is there any query to get the outstanding invoices for the specified month

Summary: Query to get the outstanding invoices for the specified month

Content (required): We need to send a csv report to a customer which contains the outstanding invoices (not paid & partially paid) for specfied month, the data should not change for example if a particular invoice was paid later on but since it was not paid during the specified month it is still considered as outstanding invoice and should be populated in the report.

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):