Filtering on related module

Filtering on related module

I have a custom module (Module1) which is related to another custom module (Module 2)
Module 1 can have many related records in Module 2.
Module 2 has a date field.
Module 1 has related list Module 2

I want to filter Module 1 to list all records where most recent related record in Module 2 is older than a certain date.

Once I have this filtered list of records I want to send each an email.

Although you can filter on Emails, Notes and Activities, I cannot see a way to filter on another related list?
Once I am able to filter I can then create a button to send the emails.

If I was doing this using PHP and MySQL or MSAccess and VBA it would take me just a few minutes using a simple query. I've spent all morning trying to work out how to do this in Zoho!