FileTime - script function

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:

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

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

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.

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