Return File Date

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

re: Return File Date

On 10 Oct 2003 13:37:42 GMT, clint2001@aol.comNoSpam (Clint Stowers)
wrote:

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

[color=blue]
>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?"[/color]

re: Return File Date

In article <rggdov8g09rfgjvdt2vkpf5lpl9ennsti6@4ax.com>, Tom van Stiphout
<tom7744@no.spam.cox.net> writes:
[color=blue]
>What part of the FileDateTime function don't you like?[/color]

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

re: Return File Date

In article <rggdov8g09rfgjvdt2vkpf5lpl9ennsti6@4ax.com>, Tom van Stiphout
<tom7744@no.spam.cox.net> writes:
[color=blue]
>What part of the FileDateTime function don't you like?[/color]

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

re: Return File Date

Well, this would be very tricky, but how about

Int( FileDateTime( pathname ) )

Roberto

"Clint Stowers" <clint2001@aol.comNoSpam> escreveu na mensagem
news:20031014063243.21232.00001214@mb-m13.aol.com...[color=blue]
> In article <rggdov8g09rfgjvdt2vkpf5lpl9ennsti6@4ax.com>, Tom van Stiphout
> <tom7744@no.spam.cox.net> writes:
>[color=green]
> >What part of the FileDateTime function don't you like?[/color]
>
> 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?"[/color]

re: Return File Date

"Clint Stowers" <clint2001@aol.comNoSpam> wrote in message
news:20031014063243.21232.00001214@mb-m13.aol.com...[color=blue]
> In article <rggdov8g09rfgjvdt2vkpf5lpl9ennsti6@4ax.com>, Tom van Stiphout
> <tom7744@no.spam.cox.net> writes:[/color]
[color=blue]
> What I would like is to return the date (mm/dd/yy) of a spicific file.[/color]

dim fDate as Variant
fDate = FileDateTime("d:\stuff\specific.txt")
MsgBox Format(fDate, "mm/dd/yy")

re: Return File Date

In article <PGbjb.58458$uA2.55360@twister.nyroc.rr.com>, "rkc"
<rkc@yabba.dabba.do.rochester.rr.com> writes:
[color=blue]
>dim fDate as Variant
>fDate = FileDateTime("d:\stuff\specific.txt")
>MsgBox Format(fDate, "mm/dd/yy")[/color]

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