topic How to convert Date into Number(int) in QlikView

How to convert Date into Number(int)

Fri, 23 Sep 2011 13:12:54 GMT

Hi All,

I was wondering how to convert DateTime field into Number(Int not decimal)

TestTemp:
load * Inline
[
TestDate
2010/01/01 12:13:00
];

load num(TestDate) as DateNum Resident TestTemp;

But you can see that the TestDate has time, so how to get the int number with num function?

Many thanks.

How to convert Date into Number(int)

its_anandrjs — Fri, 23 Sep 2011 13:20:22 GMT

Hi,

Use Date#( Datefield ) as NumDate to convert date into num

Rgds

Anand

How to convert Date into Number(int)

its_anandrjs — Fri, 23 Sep 2011 13:21:57 GMT

Hi,

You are able to use

Floor( Date ( Today( ) , 'DD/MM/YYYY' ) )

Let me know

Rgds

Anand

How to convert Date into Number(int)

SunilChauhan — Fri, 23 Sep 2011 13:22:57 GMT

try this

TestTemp:
load * Inline
[
TestDate
01/01/2011 12:13:00
];

load num(TestDate) as DateNum Resident TestTemp;

format of date should be same as format defined using set in start of edit script

Re: How to convert Date into Number(int)

its_anandrjs — Fri, 23 Sep 2011 13:24:59 GMT

Hi,

See the attached sample file.

Your inline date is not in date format.

Rgds

Anand

Re: How to convert Date into Number(int)

its_anandrjs — Fri, 23 Sep 2011 13:36:48 GMT

Hi,

Let see your date example for this date 2010/01/01 12:13:00 in sample file.

Let me know about this.

Rgds

Anand

How to convert Date into Number(int)

SunilChauhan — Fri, 23 Sep 2011 13:47:14 GMT

only you need to match the format of date given in load statement and format of date defined in start of coding.

both should be same

see my post above

How to convert Date into Number(int)

its_anandrjs — Fri, 23 Sep 2011 14:44:02 GMT

Hi,

Hope you got correct answer, if so mark it correct\Helpful on post to complete the thread.

Rgds

Anand