Last Saved Date and timestamp

Mon, 21 Jan 2013 19:48:12 GMT

Hello,

I have a document that reloads every twenty minutes. I am looking for a way to flag the "new data" and I want to use the date that the docement was last saved. Is there a way to call this date and timestamp.

Any help would be appreciated.

Thanks,

Jeff

Re: Last Saved Date and timestamp

Mon, 21 Jan 2013 19:58:15 GMT

The best solution is to use the timestamp when the script start running, to avoid any conflict if some records are changed during the document reload. An example:

Let ThisExecTime = Now( );

QV_Table:
SQL SELECT PrimaryKey, X, Y FROM DB_TABLE
WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(ThisExecTime)#;

If ScriptErrorCount = 0 then
STORE QV_Table INTO File.QVD;
Let LastExecTime = ThisExecTime;
End If

topic Last Saved Date and timestamp in QlikView

Last Saved Date and timestamp

Re: Last Saved Date and timestamp