Qlik Sense: Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename

Ask a Question

Last Update:

Aug 24, 2022 2:32:43 AM

Updated By:

Created date:

Aug 23, 2022 10:40:14 AM

With the latest versions of Qlik Sense (QS August 2021 and above), Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename. This was not the same in previous Qlik Sense versions.

Example:

With QS May 2022 SR4, FileTime() returns UTC time 11.25.41 AM instead of 1:25 PM as last modified time

file time function May 2022.png

With QS February 2021 SR15, FileTime() returns last modified time

Result_filetime() Feb 2021SR15.png

Environment

Qlik Sense Enterprise
Qlik Sense SaaS

Resolution

Defect QB-9622 was reported to R&D.

This bug was closed as Working as Designed (WAD) due to an intentional design-change. This change is documented in Qlik Sense August 2022

Documentation for August 2022.png

Cause

Product Defect ID: QB-9622 and HLP-12548

Qlik Sense: Filetime() function returns a timestamp in UTC for the date and time of the last modification of the file filename