Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How do I add "Date Created" of a file as a field in Qlikview.
Kind regards
Nayan
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?
Thank you Jonathan for your reply. By the way, what do you mean by DIR?
Kind regards
Nayan
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
Windows batch command DIR which fetches the filename and properties (batch version of \what you see in Windows Explorer).
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.