Check File Date & Time In VBA

[Mike Charney]

Is there a way to check a files date and time stamp from VBA in access.

I have a need check a date stamp on a file that I am importing.

Thanks in advance,

Mike
m charney at dunlap hospital dot org

 

[Nikos Yannacopoulos]

Mike,

Try something like:

Set fso = CreateObject("scripting.filesystemobject")
Set f = fso.getfile("C:\My Documents\SomeFile.ext")
Debug.Print f.datelastmodified

HTH,
Nikos

 

[Douglas J Steele]

No need to introduce the overhead of FSO.

The VBA FileDateTime function is sufficient:

Debug.Print FileDateTime("C:\My Documents\SomeFile.ext")

 

[Mike Charney]

How can I read just the date portion of the file date time stamp.

Mike

 

[Douglas J Steele]

Use the DateValue function:

Debug.Print DateValue(FileDateTime("C:\My Documents\SomeFile.ext"))

 

[Norman Yuan]

Since FileDateTime function returns a value of Date type, you can get Date,
Hour, Minute or Second part from it as you wish. For example:

Debug.Print Format(FileDateTime("C:\My
Documents\SomeFile.exe"),"yyyy-MM-dd")