Get last modified date for files.

[Atomic Shrimp]

I've got an app that imports and files that i drop in a given folder; after importing them, it moves them to a 'done' folder.

I would like to be able to automate the deletion of the files from the 'done' folder when they are a year old; does anyone know how to retrieve the last modified date for a file using VBA?

Thanks

Mike

 

[AccessUser]

Try FileDateTime()

 

[skiphooper]

Mike,

I found this at another site:

http://www.mvps.org/access/modules/mdl0051.htm

HTH

Skip

 

[Atomic Shrimp]

Thanks both... looks promising...

 

[Cosmos75]

Great Link!

skiphooper,

Great link, am gonna add that one to my sample database thread!
Folders & Files - List / Open / Attributes / Copy / Delete / New