BUG: FileTime> incorrect in some cases

Ideas for new features & functions

Moderators: Dorian (MJT support), JRL

Post Reply
Snickers
Macro Veteran
Posts: 150
Joined: Thu Dec 09, 2004 3:01 pm
Location: Somewhere in TX

BUG: FileTime> incorrect in some cases

Post by Snickers » Fri Jul 18, 2008 9:41 am

After creating and excel file and then drag and drop copying it over to another network folder, FileTime> collects an incorrect last modified time for the copied file.

For example, if you look at both of the files properties menus, they both will show a matching file times for created, modified, accessed (meaning file 1 created time = file 2 created time, file 1 accessed time = file 2 accessed time, etc..). However, if you check these times using FileTime> the times are incorrect. The copied file will have a 2 second EARLIER last modified time than the original file.


Recreate the error with these steps
1. Create an excel file "original" and save it
2. Right click drag "original" excel file to another folder on another network drive.
3. select COPY HERE

Run this code:

Code: Select all

goSub>subVarDeclare

FileDate>%original_PB_ExcelFilePath%,originalDate
FileTime>%original_PB_ExcelFilePath%,originalTime
FileDate>%copied_PB_ExcelFilePath%,copiedversionDate
FileTime>%copied_PB_ExcelFilePath%,copiedversionTime
MDL>%originalDate% %originalTime% %copiedversionDate% %copiedversionTime%

//subVarDeclare--------------------------------------subVarDeclare
SRT>subVarDeclare
Let>copied_PB_ExcelFilePath=...networkpath...
Let>original_PB_ExcelFilePath=...localpath...
End>subVarDeclare

Post Reply
Sign up to our newsletter for free automation tips, tricks & discounts