There are 2 methods:
1. You can create a user defined report with a query expiration date < today + x days. Schedule it to send to users you prefer on a period. This is very basic, you won't be able to do much configuration.
2. You can create a BI Publisher report and use bursting ability to send an email to users. This method gives you ability to configure a more complex delivery. Based on your query BI Publisher can filter the report on delivery and send each person the information only related to them.
Via configuration (not reporting), you can also have the BP auto-create another BP (ie. "Action Item") on a certain date, using Date condition triggers.