Get file creation date.

[QlikView_99]

Hello all,

I want to get the file creation instead of the modified date. I know there is no direct function to get the file creation time. But heard that creating a module will serve the purpose.

If anyone is aware of the process, could you please post the working process.

[Brett_Bleess]

A bit more detail is going to be required on this one to get responses, as I am not sure to what files you are referring for starters, the QVW, QVD or other data files etc.?  That is likely the first thing that needs further clarification on this post.

You can look in the Design Blog area of Community to see if you can find something there related to this, but I cannot recall for sure if I have run across something along these lines or not:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[QlikView_99]

The files for which I need the creation date are a mix xlsx, xlsm, xls, qvw, qvd, csv these are all the file types where I can get the file creation date.

[Brett_Bleess]

I hit the following Help link, but it does not appear we have any file functions to do what you want to do, so the only option would be to create your own function in the Edit Module and call that in the script.

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

Here is Help on creating custom functions:

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/VBFunctionCalls...

Only other thing would be to use Execute statement to call an external script or something to do that check for you and pass back things to us I believe.

Forgot one other thing, Idea area of Community, you can check to see if anyone has submitted a request for this functionality and if not, you can create one there:

https://community.qlik.com/t5/Ideas/idb-p/qlik-ideas

Regards,
Brett