determining date of a file

[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

 

[Douglas J. Steele]

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")

 

[Mr. T]

thx Douglas, that's what i needed!

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")