TRACE elapsed timespan in a QVW script

[#1]

Hi, I'm trying to the following in a QVW script, and am missing something in how I calculate the duration:

LET vStartTime = Now();

// [Do something that takes a few minutes]

LET vEndTime = Now();

LET vDuration = $(vEndTime) - $(vStartTime);  // SCRIPT ERROR

TRACE Elapsed time: $(vDuration);

I would have thought that Using TRACE to capture the Elapsed Reload time would have answered this question, but it's missing the timespan/duration/elapsed part.  I've tried using the Interval() function, but so far without success.

Can anyone correct this script?  Thanks.

[srchilukoori]

Try the script below.

LET vStartTime = Now();

// [Do something that takes a few minutes]

SLEEP  10000;

LET vEndTime = Now();

LET vDuration = Timestamp#('$(vEndTime)') - Timestamp#('$(vStartTime)'); 

TRACE Elapsed time: $(vDuration);

[#3]

Very close -- now just trying to format result in seconds...

[srchilukoori · Accepted solution]

Try this :

LET vDuration = Interval(Timestamp#('$(vEndTime)') - Timestamp#('$(vStartTime)'), 'hh:mm:ss'); 

[#5]

Perfect, thank you!

[maykerreyes]

Excellent!!!!