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.
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