Return File Date

[Clint Stowers]

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

[Tom van Stiphout]

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

[Clint Stowers]

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

[Clint Stowers]

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

[Roberto Spier]

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

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

[Clint Stowers]

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