Referencing Time

[#1]

My question is how do I reference a time stamp?

Here is my problem:

I have a system in place where I can drop files into a directory. From there I ingest the files into qlik to make a report. How do I reference the time stamp when the file was dropped into the directory? For example, I dropped the file into the directory on the 3rd but I'm making the report on the 8th and I need to be able to reference that date and time of the 3rd.

Any help would be appreciated.

[Anonymous · Accepted solution]

Try filetime() function:

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

[#3]

I am trying it right now. Thank you!

[#4]

That worked. Thank you!