Last Saved Date and timestamp

[#1]

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

[#2]

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