Thread: Put only date (not time too) in variable from FileDateTime function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mikeburg[_64_] mikeburg[_64_] is offline
external usenet poster
  
Posts: 1
Default 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


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

Reply With QuoteReply With Quote