FileDateTime

Returns the date and time of when a file was created or last modified.

Syntax
      FileDateTime (file_path)

Key
   file_path   The file to inspect.

The FileDateTime() function may be used in VBA or in an SQL query.

Example

Dim dtmDemo As Date

dtmDemo = FileDateTime(F:\demo.xls)

“By the time a man realizes that maybe his father was right, he usually has a son who thinks he’s wrong” ~ Charles Wadsworth

Related:

Standard date and time notation - YYYY-MM-DD


© Copyright SS64.com 1999-2013
Some rights reserved