check file date

[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?

 

[Dirk Goldgar]

In

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?

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

 

[Douglas J. Steele]

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

 

[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 -

Thanks, works like a charm