If you can add a record to the table (nothing uses the table without specifying fields), you can add a BEFORE UPDATE trigger to set a new last-modified field to the current date. The end-of-day program can use WHERE lastModified=CURRENT DATE.
If that won’t work, you can add an AFTER UPDATE trigger to write record IDs into a new file. The end-of-day program can read that new file, process the records logged there, then clear the log file.
Sheldon Linker (firstname.lastname@example.org)
Linker Systems, Inc. (www.linkersystems.com)