Skip to main content

FileTime - script function

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:  

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.

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!

Join the Analytics Modernization Program

Remove banner from view

Modernize without compromising your valuable QlikView apps with the Analytics Modernization Program. Click here for more information or reach out: ampquestions@qlik.com