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. 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

Argument

Description

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

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 – please let us know!

Leave your feedback here

FileTime - script function

Did this page help you?

Join the Analytics Modernization Program