topic Re: How to get the date a document was saved? in QlikView

How to get the date a document was saved?

marcel_olmo — Thu, 16 Jan 2014 15:07:38 GMT

Hey guys, I have a QV document which reads from some excels.

Those excel documents, are changed every night, but I'd like to know via Qlikview if there's some function to get the date a document was saved in order to get if there was an error upgrading a document.

Many thanks in advance.

Regards, Marcel.

Re: How to get the date a document was saved?

brindlogcool — Thu, 16 Jan 2014 15:14:34 GMT

If the filename is with the date then you can use the Filename() function to get it.Also you can use filetime() function.

Re: How to get the date a document was saved?

Thu, 16 Jan 2014 15:16:23 GMT

FileTime()

Re: How to get the date a document was saved?

Anonymous — Thu, 16 Jan 2014 16:36:04 GMT

Check out filetime to get date a doc is saved:

filetime( [ filename ] )

Eg: filetime( 'abc.xls' )

Returns a timestamp for the date and time of the last modification of the file abc.xls.

If no filename is specified, the filetime( ) function will refer to the currently read table file.

Load *, filetime() as FT from File1.txt ;

Will return the date and time of the last modification of the file (File1.txt) as a timestamp in field FT in each record read.

Re: How to get the date a document was saved?

marcel_olmo — Thu, 16 Jan 2014 17:13:12 GMT

Thanks guys! But I'm also facing another problem. My documents are in an external FTP folder, and when I'm recovering the file, I get a null value when I call filetime() function :

You can see what I'm talking about in the following thread :

Filetime does not work when refrering to external folder

Regards, Marcel.

Re: How to get the date a document was saved?

brindlogcool — Thu, 16 Jan 2014 17:20:45 GMT

An workaround would be have the dynamic file name with date(for ex Filename01162014) and you can use the filename function to get it.