Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Referencing Time

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

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

Not applicable
Author

I am trying it right now. Thank you!

Not applicable
Author

That worked. Thank you!