topic Re: Timestamp# issue in QlikView

Timestamp# issue

Tue, 01 Oct 2013 23:10:20 GMT

Hi Guys

I have a simple testing code

let cdate = Timestamp('41541.7729050926');

// cdate is 2013-09-24 18:32:59

let gdate = Timestamp#(cdate);

I am expecting gdate to be '41541.7729050926' but it just same as cdate i.e. 2013-09-24 18:32:59.

what wrong am i doing here?

Saurabh

Re: Timestamp# issue

swuehl — Tue, 01 Oct 2013 23:33:07 GMT

First, you need to use a number as argument to Timestamp(), not a string,

let cdate = Timestamp('41541.7729050926');

won't assign anything to cdate, use

let cdate = Timestamp( 41541.7729050926 );

Then, Timestamp#() is interpreting a string and setting the numeric representation, but it will return the text representation in this context (and the variable will only hold the text representation, no dual value).

You'll need to use num() function to get the numeric representation:

let gdate = num(Timestamp#(cdate));

Please have a look also into http://community.qlik.com/docs/DOC-3102

Re: Timestamp# issue

Tue, 01 Oct 2013 23:36:45 GMT

Thanks...

It works...

Re: Timestamp# issue

preminqlik — Wed, 02 Oct 2013 06:11:12 GMT

let gdate = num#(Timestamp#(Timestamp('41541.7729050926')));