How to find objects modified since a certain date

   SELECT *
     FROM sys.all_objects
    WHERE modify_date > '20120628 00:00:00'