Due to an FTP-related oversight in creating a system backup and following a recovery operation, all of the modified dates (per the system, Windows 7) of the files were reset to the date of the backup, rather than the original date modified. For many of these files, I need to know when they were created or last edited.
I've been able to restore the modified date of image files using ExifTool by applying the EXIF "Date taken" to the Windows "Date modified". However, I still have several thousand files of various types which all have the date of the backup as the "Date modified".
Many of these files are Office documents (Excel and Word, primarily) or PDFs and I know the metadata for these files contains a date that, while not necessarily the previous modified date, is a reasonable substitute.
Complicating this situation is the fact that I haven't found a consistent date field between various files. For many, the Office metadata field "Date last saved" is correct, however I'm finding files for which the "Date last saved" is actually the (incorrect) date of the backup. Further, while I'm able to view the relevant date of Office documents by right-clicking on the file and selecting Properties>Details, for PDF files, I have to actually open the file and click on File>Properties>Description to see the metadata dates.
Ideally what I'd like to do is the following:
Reset the Windows "Date created" to the Office "Content created" or Acrobat "Created" date as per the file's metadata
Reset the Windows "Date modified" to the Office "Date last saved" or Acrobat "Modified" date as per the file's metadata
However, if the Office "Date last saved" is the date of the backup (say, 12/31/2013), I'd like the Windows "Date modified" to reset to the Office "Date last printed" or, if that doesn't exist, ultimately the Office "Content created" date (in the last case, the Windows "Date created" and "Date modified" would be identical).
Does an application or a script exist that will do the above? I've tried searching the Internet for a solution, but I've not been able to uncover anything particularly useful.
Any help would be greatly appreciated. Thanks in advance.