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

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mikeburg" wrote in
message ...

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" wrote in
message ...

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


--
mikeburg
------------------------------------------------------------------------
mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581
View this thread: http://www.excelforum.com/showthread...hreadid=503681