Find record with previous date?

Is there a way I can use a formula query to, using a set of criteria, find the record with a previous date?

ie - return the maximum date that is prior to the current date.

Example:

My query narrows down to records with these due dates:

1-2-22
4-5-22
7-7-22
10-20-22

The earliest date returns nothing
Record with 4-5-22 returns 1-2-22
Record with 7-7-22 returns 4-5-22
etc...

There will be no ties so that is not a worry

------------------------------
Mike Tamoush
------------------------------