topic Re: Filetime in QMC different from Filetime in Desktop in QlikView

Filetime in QMC different from Filetime in Desktop

Catallin — Mon, 26 Jan 2026 18:19:17 GMT

When I reload the qvw from Qlikview Desktop the filetime function works correctly but when I do the same reload from the QMC, the time shown is 2 hours back from the correct time.

Any ideas why this happens?

Thanks

Re: Filetime in QMC different from Filetime in Desktop

Ray_Strother — Mon, 13 Mar 2023 17:16:24 GMT

Hello ,

1. Are the Qlikview server and Qlikview desktop on the same machine?

2. Have you reviewed the help for the filetime function?

https://help.qlik.com/en-US/qlikview/May2022/Subsystems/Client/Content/QV_QlikView/Scripting/FileFunctions/FileTime.htm

Re: Filetime in QMC different from Filetime in Desktop

Catallin — Mon, 13 Mar 2023 18:19:19 GMT

Hello Ray,

1. Yes

2. Yes, never had this problem before. The date in the filetime() function was the same as the modified date of the file in File Explorer.

Just updated the QlikView Server to May 2022 SR1, if it helps.

Re: Filetime in QMC different from Filetime in Desktop

Ray_Strother — Mon, 13 Mar 2023 18:29:13 GMT

What version did you upgrade from?

Re: Filetime in QMC different from Filetime in Desktop

Catallin — Mon, 13 Mar 2023 18:38:03 GMT

12.10.20400.0

Re: Filetime in QMC different from Filetime in Desktop

Catallin — Mon, 13 Mar 2023 18:54:54 GMT

So I just noticed in help that the function changed from May 2021 - link to May 2022 - link .

Now the function displays the UTC time instead of the actual time when the file was modified. Why was this changed?

This would explain why there is a difference between QlikView Desktop and QlikView Server, as the Desktop version is May 2021 SR2.

Re: Filetime in QMC different from Filetime in Desktop

Ray_Strother — Mon, 13 Mar 2023 19:04:50 GMT

Hello,

1. The Qlikview Server and Desktop need to be the same version.

2. Please review the below link and confirm things are aligned.

3. The change I believe was R&D attempt to align formats across products and logs

Re: Filetime in QMC different from Filetime in Desktop

Catallin — Mon, 13 Mar 2023 19:53:58 GMT

I installed QV Desktop May 2022 version, I get the same results as in QV Server now.

Even if R&D wanted to align formats, they could have simply created a new function, something like filetimeUTC(), not rewrite the original filetime() function...

Funny thing is that if I create a textbox with time(Now()) inside it, it gives me the current local time, not UTC time.. Not great when it comes to aligning formats, isn't it?

Re: Filetime in QMC different from Filetime in Desktop

Ray_Strother — Mon, 13 Mar 2023 20:12:22 GMT

Here is a little more information. I don't believe. you can alter the configuration.

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Sense-and-QlikView-version-12-Logs-Timestamp-Format/ta-p/1714064