topic Date conversion to Number in QlikView

Date conversion to Number

Wed, 12 Nov 2014 17:09:32 GMT

I need to convert a date field into Numeric.

Num(Date ( 2014/11/12 , 'YYYYMMDD' ) )

output expecting:20141112

The num function giving me the result but not the way I was expecting.Any help on this would be great.

Re: Date conversion to Number

Anonymous — Wed, 12 Nov 2014 17:10:21 GMT

Try something like this

Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) )

Re: Date conversion to Number

Anonymous — Wed, 12 Nov 2014 17:11:06 GMT

Or maybe even this :

date ( (Date# ( '2014/11/12' , 'YYYY/MM/DD' ), 'YYYYMMDD' )

Re: Date conversion to Number

agomes1971 — Wed, 12 Nov 2014 17:12:17 GMT

Hi,

see this:

Num(Date#(Field, 'MM/DD/YYYY')) AS NumericDate

Regards

André Gomes

Re: Date conversion to Number

its_anandrjs — Wed, 12 Nov 2014 17:12:38 GMT

Try in place of the NUM with Date#

=Date (Date#('2014/11/12' , 'YYYY/MM/DD' ) ,'YYYYMMDD')

Regards

Anand

Re: Date conversion to Number

shree909 — Wed, 12 Nov 2014 17:14:09 GMT

Try this

=Date ( Floor(Date# ( '2014/11/12' , 'YYYY/MM/DD' )), 'YYYYMMDD' )

Re: Date conversion to Number

its_anandrjs — Wed, 12 Nov 2014 17:14:11 GMT

Or you can try

=Date(Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) ),'YYYYMMDD')

Regards

Anand

Re: Date conversion to Number

ashfaq_haseeb — Wed, 12 Nov 2014 17:16:27 GMT

Hi,

This should work

=Date(Date#('2014/11/12','YYYY/MM/DD') ,'YYYYMMDD')

Regards

ASHFAQ

Re: Date conversion to Number

rwunderlich — Wed, 12 Nov 2014 17:22:24 GMT

If you really want the *numeric* value to be 20141112, then I think it would be done like this:

=num#(Date(Date#('2014/11/12','YYYY/MM/DD') ,'YYYYMMDD'),'0')

-Rob

Re: Date conversion to Number

Wed, 12 Nov 2014 19:16:12 GMT

Thanks Rob.It is always a pleasure to see you here.Yes I wanted to have a numeric value because at the end I am going to comapre this date converted numeric vaule with another Numeric field.Thanks again for your help.

Re: Date conversion to Number

its_anandrjs — Wed, 12 Nov 2014 20:41:46 GMT

Hi,

Yes Rob is right

If want to exactly number then use it

=Date(Num(Date# ( '2014/11/12' , 'YYYY/MM/DD' ) ),'YYYYMMDD')

If want exactly Date then write like

=Date (Date#('2014/11/12' , 'YYYY/MM/DD' ) ,'YYYYMMDD')

Regards

Anand