By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,647 Members | 1,604 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,647 IT Pros & Developers. It's quick & easy.

Check File Date & Time Stamp

P: n/a
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
Apr 18 '06 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Mike Charney wrote:
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

Check out filedatetime function in help.
Apr 18 '06 #2

P: n/a

"salad" <oi*@vinegar.com> wrote in message
news:nr***********@newsread4.news.pas.earthlink.ne t...
Mike Charney wrote:
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

Check out filedatetime function in help.


Thanks that is what I was looking for.

Mike
Apr 18 '06 #3

P: n/a
How can I read just the date portion of the file date time stamp.

Mike
"Mike Charney" <no*****@everything.net> wrote in message
news:WP******************@newssvr25.news.prodigy.n et...

"salad" <oi*@vinegar.com> wrote in message
news:nr***********@newsread4.news.pas.earthlink.ne t...
Mike Charney wrote:
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

Check out filedatetime function in help.


Thanks that is what I was looking for.

Mike

Apr 18 '06 #4

P: n/a
Could you not just enclose the FileDateTime function with DateValue??

Something like DateValue (FileDateTime("C:\YourFilePath.txt"))

Regards,

Mark

"Mike Charney" <no*****@everything.net> wrote in message
news:yf******************@newssvr25.news.prodigy.n et...
How can I read just the date portion of the file date time stamp.

Mike
"Mike Charney" <no*****@everything.net> wrote in message
news:WP******************@newssvr25.news.prodigy.n et...

"salad" <oi*@vinegar.com> wrote in message
news:nr***********@newsread4.news.pas.earthlink.ne t...
Mike Charney wrote:
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
Check out filedatetime function in help.


Thanks that is what I was looking for.

Mike


Apr 18 '06 #5

P: n/a
I enclosed the date in a format( ) using mm-dd-yyyy and it worked great.

Working on email from access problem now.

Mike

"Mark" <ma*********@ntlworld.com> wrote in message
news:rH***************@newsfe3-win.ntli.net...
Could you not just enclose the FileDateTime function with DateValue??

Something like DateValue (FileDateTime("C:\YourFilePath.txt"))

Regards,

Mark

"Mike Charney" <no*****@everything.net> wrote in message
news:yf******************@newssvr25.news.prodigy.n et...
How can I read just the date portion of the file date time stamp.

Mike
"Mike Charney" <no*****@everything.net> wrote in message
news:WP******************@newssvr25.news.prodigy.n et...

"salad" <oi*@vinegar.com> wrote in message
news:nr***********@newsread4.news.pas.earthlink.ne t...
Mike Charney wrote:
> 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
Check out filedatetime function in help.

Thanks that is what I was looking for.

Mike



Apr 18 '06 #6

P: n/a
Mike Charney wrote:
How can I read just the date portion of the file date time stamp.

Mike
"Mike Charney" <no*****@everything.net> wrote in message
news:WP******************@newssvr25.news.prodigy.n et...
"salad" <oi*@vinegar.com> wrote in message
news:nr***********@newsread4.news.pas.earthlink. net...
Mike Charney wrote:

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

Check out filedatetime function in help.


Thanks that is what I was looking for.

Mike


Remember, using Format will create a string. It's best to stuff a table
field with the date and use Format for the display. Also, if you use a
Now() type value with date/time and you query on date ranges, you need
to add an extra day to the range. For example, Between #1/1/2006# And
#1/1/2006# will return only records on 1/1/2006 with a time of 00:00:00.
You would want Between #1/1/2006# And #1/2/2006# to get records with
any other time but 00:00:00.
Apr 18 '06 #7

This discussion thread is closed

Replies have been disabled for this discussion.