We do not recommend using SQL to change the creation date on files checked into Harvest. It’s not just a matter of updating the date in one table, there would be several things that would have to be changed accordingly. We could be creating other problems by doing it this way.
So, to avoid those problems, what we can do instead is to put the original date and time into the version’s description field instead. Like this:
<Please see attached file for image>
I wrote a quick Windows batch script that would accomplish this. It’s attached. To execute, edit the script and adjust the environement variable settings at the top to reflect the correct information about your broker, project, state, etc. Then run it from your Windows computer containing the files you want to check in.