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 can be used in VBA or in an SQL query.

Examples

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 © 1999-2024 SS64.com
Some rights reserved