topic Today(0) function doesn't seem to work correctly? in QlikView

Today(0) function doesn't seem to work correctly?

Wed, 24 Oct 2012 15:52:34 GMT

Hi All

I have an unusal problem. In my load script, I am using the function today(0) as TodayDate.

The problem I noticed is that every now and then, the today(0) doesn't seem to work. I have load it twice in order for the date to update correctly to doday. I'm on Windows 7 64 bit and qlikview 11 r1.

Any ideas?

Thanks

Re: Today(0) function doesn't seem to work correctly?

swuehl — Wed, 24 Oct 2012 16:00:13 GMT

Timer mode 0, date at script run time actually means the time of finishing the script run, i.e. the timestamp of the last succesful script run (in QV11 SR1, I think they changed this in SR2).

You probably need the timestamp at function call (argument timer mode = 1)

today(1)

Regards,

Stefan