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.
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
Standard date and time notation - YYYY-MM-DD