Finding most recent date only

[Alec Smith]

Hi all -

I've got a database along the lines of the following

----------------  -------------- ----------------
| Transactions |  | Products   | | TransDetails |
----------------  -------------- ----------------
| TransID      |  | ProdID     | | TransID      |
| TransDate    |  | ProdName   | | ProdID       |
| .....        |  | ....       | | .....        |
----------------  -------------- ----------------

(I have replaced a bunch of other fields with ....  for briefity)

What I need to be able to do is get a list of all products not having a
transaction since a certain date, but am not having much luck. Anyone out
there willing to offer save my day?

Thanks!