Checking a file's date 3

[nickperez22]

I have a backup routine that compacts and zips the backend before opening an application. This process can take anywhere from 2-5 minutes. I would like to be able to check the zip drive file to see if a backup was already done today and if so skip the compact and backup routine, however I do not know the code to check a file's date.

 

[RoyVidar]

Check the helpfiles on the DateCreated property (filesystemobject) or the FileDateTime function.

Roy-Vidar

 

[PHV]

Take a look at the FileDateTime function:
theTimeStamp = FileDateTime(thePathName)
or:
If CLng(FileDateTime(thePathName)) = CLng(Date()) Then
MsgBox "Already backuped today"
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[nickperez22]

Thanks so much to both of you. I never knew there was a FileDateTime function in Access.

 

[pweegar]

You could also set a flag in your backup procedure, and set it to true when the backup is done successfully (Maybe store the results in a table with the date/time). And then display a message when the app opens as to the success or failure of the backup. If the backup fails, notify the user that a backup needs to be performed. This might be a bit faster than openning the zip drive and doing a search for the backup file. What happens if someone removes the disk from the zip driveprior to openning the app?