Put only date (not time too) in variable from FileDateTime function

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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikeburg" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

i've always just used format

Format(FileDateTime("C:\USR\MIKE\AT0158.MB"), "mm/dd/yy")

--


Gary


"mikeburg" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

Thanks again, guys. If it were not for y'all, people like me would probably give up trying to learn VBA. mikeburg