The FileTime function returns a timestamp in UTC 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. |
