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

Return File Date

P: n/a
Using Acc2k

Can anyone suggest some sample code for returning the date of a Linked File?

I am linking MyFile.xls as tblMyFile. Simply put, somewhere on a form I would
like to the date of the xls file.

Any suggestion appreciated.

Thanks in advance

"And.... Exactly at which point did you consider this a good idea?"
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On 10 Oct 2003 13:37:42 GMT, cl*******@aol.comNoSpam (Clint Stowers)
wrote:

What part of the FileDateTime function don't you like?
-Tom.

Using Acc2k

Can anyone suggest some sample code for returning the date of a Linked File?

I am linking MyFile.xls as tblMyFile. Simply put, somewhere on a form I would
like to the date of the xls file.

Any suggestion appreciated.

Thanks in advance

"And.... Exactly at which point did you consider this a good idea?"


Nov 12 '05 #2

P: n/a
In article <rg********************************@4ax.com>, Tom van Stiphout
<to*****@no.spam.cox.net> writes:
What part of the FileDateTime function don't you like?


Just the date. Would be nice to know how current is the file. Time is of no
value.

"And.... Exactly at which point did you consider this a good idea?"
Nov 12 '05 #3

P: n/a
In article <rg********************************@4ax.com>, Tom van Stiphout
<to*****@no.spam.cox.net> writes:
What part of the FileDateTime function don't you like?


Seems like Tom has gotten redirected.

What I would like is to return the date (mm/dd/yy) of a spicific file.

"And.... Exactly at which point did you consider this a good idea?"
Nov 12 '05 #4

P: n/a
Well, this would be very tricky, but how about

Int( FileDateTime( pathname ) )

Roberto

"Clint Stowers" <cl*******@aol.comNoSpam> escreveu na mensagem
news:20***************************@mb-m13.aol.com...
In article <rg********************************@4ax.com>, Tom van Stiphout
<to*****@no.spam.cox.net> writes:
What part of the FileDateTime function don't you like?


Seems like Tom has gotten redirected.

What I would like is to return the date (mm/dd/yy) of a spicific file.

"And.... Exactly at which point did you consider this a good idea?"

Nov 12 '05 #5

P: n/a
rkc

"Clint Stowers" <cl*******@aol.comNoSpam> wrote in message
news:20***************************@mb-m13.aol.com...
In article <rg********************************@4ax.com>, Tom van Stiphout
<to*****@no.spam.cox.net> writes: What I would like is to return the date (mm/dd/yy) of a spicific file.


dim fDate as Variant
fDate = FileDateTime("d:\stuff\specific.txt")
MsgBox Format(fDate, "mm/dd/yy")
Nov 12 '05 #6

P: n/a
In article <PG*******************@twister.nyroc.rr.com>, "rkc"
<rk*@yabba.dabba.do.rochester.rr.com> writes:
dim fDate as Variant
fDate = FileDateTime("d:\stuff\specific.txt")
MsgBox Format(fDate, "mm/dd/yy")


Sorry for not getting back sooner. Had one of Unscheduled Emergencies.

Looks like it will do the trick.

Thanks.


"And.... Exactly at which point did you consider this a good idea?"
Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.