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]

Re: Return File Date

On 10 Oct 2003 13:37:42 GMT, clint2001@aol.c omNoSpam (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]

[Clint Stowers]

Re: Return File Date

In article <rggdov8g09rfgj vdt2vkpf5lpl9en nsti6@4ax.com>, Tom van Stiphout
<tom7744@no.spa m.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?"

[Clint Stowers]

Re: Return File Date

In article <rggdov8g09rfgj vdt2vkpf5lpl9en nsti6@4ax.com>, Tom van Stiphout
<tom7744@no.spa m.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?"

[Roberto Spier]

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:2003101406 3243.21232.0000 1214@mb-m13.aol.com...[color=blue]
> In article <rggdov8g09rfgj vdt2vkpf5lpl9en nsti6@4ax.com>, Tom van Stiphout
> <tom7744@no.spa m.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]

[rkc]

Re: Return File Date


"Clint Stowers" <clint2001@aol. comNoSpam> wrote in message
news:2003101406 3243.21232.0000 1214@mb-m13.aol.com...[color=blue]
> In article <rggdov8g09rfgj vdt2vkpf5lpl9en nsti6@4ax.com>, Tom van Stiphout
> <tom7744@no.spa m.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\specifi c.txt")
MsgBox Format(fDate, "mm/dd/yy")

[Clint Stowers]

Re: Return File Date

In article <PGbjb.58458$uA 2.55360@twister .nyroc.rr.com>, "rkc"
<rkc@yabba.dabb a.do.rochester. rr.com> writes:
[color=blue]
>dim fDate as Variant
>fDate = FileDateTime("d :\stuff\specifi c.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?"