topic load script - get actual time with milliseconds in QlikView

load script - get actual time with milliseconds

Mon, 17 May 2010 16:51:32 GMT

Hi,

how is it possible to get the actual time with milliseconds in the load script. I need to query the time (like the function now()) but with the precision of milliseconds.

Thanks in advance

load script - get actual time with milliseconds

Mon, 17 May 2010 20:48:46 GMT

Hi Rabbit,

Unfortunately the now() function only returns timestamp to the second... even when attempting to reformat with fff (which should show fractions of a second to 3 decimal places).

The only way I could get millisecs was to:
1_ execute an external command that stores the current timestamp in a file
2_ read the file into a table
3_ peek to get the value into a variable.

Perhaps someone else on the forum could come up with a solution using macros...

load script - get actual time with milliseconds

Mon, 17 May 2010 23:50:27 GMT

In the load script, we run an EXECUTE command to create the mydate.txt file.

In order for this to run correctly, you need to make sure that the "Can Execute External Programs" box is checked on the load script settings tab.

Also, be sure to click the "Give System Access" button that pops up when you reload. I haven't tested this on server yet, so I'm not sure if it will requrie additional setup.

load script - get actual time with milliseconds

rwunderlich — Tue, 18 May 2010 01:51:51 GMT

You can use the VBScript Timer function in a macro function and call that from the load script. See attached.

-Rob

(Caution QVS SR4 has problems with custom macro functions - bug #27945)