Display recently updated documents in SharePoint
Well, it should be a lot eaiser than this, but Joel Ward figured out how to do it.
http://joelsef.blogspot.com/2006/05/recently-updated-documents-in.html
Maybe there will be an eaiser way in SharePoint 2007.