The FileTime function returns a timestamp for the date and time of the last modification of the file filename. If no filename is specified, the function will refer to the currently read table file.
Syntax:
FileTime([ filename ])
Arguments:
- filename: The name of a file, if necessary including path.
-
absolute
Example: c:\data\
-
relative to the QlikView document path.
Example: data\
-
URL address (HTTP or FTP), pointing to a location on the Internet or an intranet.
Example: http://www.qlik.com
Examples and results:
| Example | Result |
|---|---|
|
LOAD *, FileTime( ) as X from abc.txt; |
Will return the date and time of the last modification of the file (abc.txt) as a timestamp in field X in each record read. |
| FileTime( 'xyz.xls' ) | Will return the timestamp of the last modification of the file xyz.xls. |
