Check File Date & Time Stamp

[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

[salad]

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.

[Mike Charney]

"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

[Mike Charney]

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

[Mark]

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

[Mike Charney]

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

[salad]

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.