How to calculate LastExecTime and BeginningThisExecTime?

[#1]

Hi,

Is this ok?

let BeginningThisExecTime=now();

let LastExecTime=reloadtime();

And what doese the meaning of # in page502 in reference manual:

WHERE ModificationTime >= #$(LastExecTime)#
AND ModificationTime < #$(BeginningThisExecTime)#;

[Oleg_Troyansky · Accepted solution]

if you want to store formatted timestamps as strings in your variable, then your statements are fine. If you rather want the numeric values, then enclose your values in function num().

Not sure about the meaning of # in the manual. I'm guessing that they offer an example based on a specific database, so this syntax may belong to the database rather than QlikView... You need to follow the rules relevant to your Database syntax.

The $() - expansion returns the value of the variable. Based on your SQL syntax, you may need to enclose it in single quotes or any other special symbols...

cheers,

[#3]

Hi Oleg,

Thanks for your reply 🙂

[Oleg_Troyansky]

no problem, any time 🙂