FileTime - script function

The FileTime function returns a timestamp in UTC format of the last modification of a specified file. If a file is not specified, the function returns a timestamp in UTC of the last modification of the currently read table file.

Syntax:

FileTime([ filename ])

Arguments:

Arguments
Argument	Description
filename	The name of a file, if necessary including path, as a folder or web file data connection. Example: 'lib://Table Files/' In legacy scripting mode, the following path formats are also supported: absolute Example: c:\data\ relative to the Qlik Sense app working directory. Example: data\ URL address (HTTP or FTP), pointing to a location on the Internet or an intranet. Example: http://www.qlik.com

Script examples
Example	Result
LOAD *, FileTime( ) as X from abc.txt;	Will return the timestamp of the last modification of the file (abc.txt) in field X in each record read.
FileTime( 'xyz.xls' )	Will return the timestamp of the last modification of the file xyz.xls.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here