Discussion Board for collaboration on QlikView Scripting.
Hello, I would like to load the "last changed" date of several qvd files. For example a file called Budget.qvd, last changed 2013-09-04 - then I would like "2013-09-04" as a value in a field in the QV app. Is this possible?
Go to Solution.
Are you referring to the last modification timestamp of the file or some internal data table?
If you are after the file timestamp, look into
filetime([ filename ])
Returns a timestamp for the date and time of the last modification of the file filename. If no filename is specified, the function will refer to the currently read table file.
filetime( 'xyz.xls' )
Will return the timestamp of the last modification of the file xyz.xls.
Load *, filetime() as X from abc.txt ;
Will return the date and time of the last modification of the file (abc.txt) as a timestamp in field X in each record read.
Returns the XML-header time stamp from a QVD file if any (otherwise NULL).
The filename is the name of a QVD file, if necessary including path.
Thanx, FileTime() was what I was looking for. Not really sure what QvdCreateTime() is. Is that when the store was initiated?
If you move the qvd from a folder to another you will have a different result for FileTime() whereas QvdCreateTime() will still give you the date when data was stored into the file.