check file date

T

tecas

I am importing a text file daily at 4:30 am and i want to check that
the file i am importing is later than 4:30 am from the previous day.
is there a way to check the file's modified date and time using the
Dir function or is there another function available?
 
D

Dirk Goldgar

In
tecas said:
I am importing a text file daily at 4:30 am and i want to check that
the file i am importing is later than 4:30 am from the previous day.
is there a way to check the file's modified date and time using the
Dir function or is there another function available?
Click to expand...

In the VB Editor environment, look up the FileDateTime function in the
online help.
 
D

Douglas J. Steele

There's a built-in FileDateTime function that returns the Last Modified
date.
 
T

tecas

There's a built-in FileDateTime function that returns the Last Modified
date.

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)






- Show quoted text -
Click to expand...

Thanks, works like a charm
 
Top