determining date of a file

  • Thread starter Thread starter Mr. T
  • Start date Start date
M

Mr. T

Hi,

i need to be able to determine the date of a file in a directory. More
specific, i need to know the most recent modified file in a directory.

Is this possible from within my Access Module?

Thx in advance!

Mr. T
 
VBA has a built-in FileDateTime function that'll give you that. Pass the
full path as the sole argument to the function:

dtmLastUpdate = FileDateTime("D:\Data\MSAccess\Sample.mdb")
 
thx Douglas, that's what i needed!

Douglas J. Steele said:
VBA has a built-in FileDateTime function that'll give you that. Pass the
full path as the sole argument to the function:

dtmLastUpdate = FileDateTime("D:\Data\MSAccess\Sample.mdb")
Click to expand...
 
Back
Top