How to capture the time when the input file is created/updated? (Not data reload time())

[su_pyae]

Hello everyone, 

I have a question. I would like to know if it is possible to capture the timestamp of the input file (like when it's created/updated). 

I don't want the data reload time because I want to monitor whether we are using the old files or not for the data. 

For example, if I am using a QVD file as an input in April but that file was created in Mar, it means I am using the old QVD file. 

Thank you!

[vchuprina · Accepted solution]

Hi, 

You can use filetime and qvdcreatetime functions

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/FileFun...

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Scripting/FileFun...

Regards,

Vitalii

[vchuprina]

For Excel files you can use macro

https://community.qlik.com/t5/QlikView-App-Dev/time-and-date-of-created-file-much-like-filetime/td-p...

Once you add it to your document, you can use it as a function

And for QVD I think it's not possible to know when the file was created, but you can track changes if you need.

As in example below

https://support.qlik.com/articles/000010330

Regards,

Vitalii

[su_pyae]

Thank you. 

I was able to use the filetime to get what I need.