View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Hotbird Hotbird is offline
external usenet poster
 
Posts: 18
Default Testing Time /Date stamps of Files

Thank you for these ideas Tom. I now have 2 avenues to follow up.

? cdate("2/12/93 4:35:47 PM")
2/12/93 4:35:47 PM
vDt = cdate("2/12/93 4:35:47 PM")
? hour(vDt),minute(vDt),second(vDt) & vbNewLine &
year(vDt),month(vDt),Day(vdt)
16 35 47
1993 2 12

"Tom Ogilvy" wrote in message
? typename(filedatetime("c:\testfile.txt"))
Date