dtFileDate = Int(FileDateTime("C:\USR\MIKE\AT0158.MB"))

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikeburg" <mikeburg.22024b_1137872102.0216@excelforum-nospam.com> wrote in
message news:mikeburg.22024b_1137872102.0216@excelforum-nospam.com...
>
> What would be the syntx for the variable, dtFileDate to contain only the
> date (not the time) from the FileDateTime function? For example put
> 1/21/2006 in the variable dtFileDate when FileDateTime is 1/21/2006
> 11:57:16 AM?
>
> In other words, from:
> dtFileDate = FileDateTime("C:\USR\MIKE\AT0158.MB")
>
> I need dtFileDate to contain only the date 1/21/2006 (not the time
> 11:57:16 AM, too).
>
> Thanks so very much. mikeburg
>
>
> --
> mikeburg
> ------------------------------------------------------------------------
> mikeburg's Profile:
http://www.excelforum.com/member.php...o&userid=24581
> View this thread: http://www.excelforum.com/showthread...hreadid=503681
>