"Created Date" how to add as a field

[Anonymous]

Hi

How do I add "Date Created" of a file as a field in Qlikview. 

Kind regards

Nayan

[jonathandienst]

Qlikview's FileTime() function gets the last modified date. I don't know of a simple way to get the created date.

Maybe running a DIR with the correct options to a file in a batch and then reading the file?

[Anonymous]

Thank you Jonathan for your reply.   By the way, what do you mean by DIR?

Kind regards

Nayan

[devarasu07]

Hi,

DIR means Directory.

simply u can add new column in your load script like below example

load *,

filetime() As Datecreate

from excelData.xls;

FileTime - script function ‒ QlikView

Thanks,Deva

[jonathandienst]

Windows batch command DIR which fetches the filename and properties (batch version of \what you see in Windows Explorer).

[jonathandienst]

FileTime() is not the created date, but last modified date. From the link you posted:

The FileTime function returns a timestamp for the date and time of the last modification of the file filename.