Like to generate a report that lists equipment based off of an expiration date

What we do is keep track of inspections of many clients with many pieces of equipment. Each piece of equipment has a date of inspection and we need to run a report prior to the expiration of the date (typically one year) to allow us to contact and schedule another inspection.