topic Re: Convert Numeric to Date in QlikView

Convert Numeric to Date

Mon, 14 Jan 2013 13:57:27 GMT

Hello,

A simple question from a Qlikview personal edition user. I'm using an Oracle database with a numeric column which looks like the follow:

DATUM_AANVRAAG

20060929

20061109

20061114

20070219

20070906

How can i load these numbers so that the become a date? So that for example 20060929 become 29-09-2006.

MayilVahanan — Mon, 14 Jan 2013 14:01:11 GMT

=Date(Date#(20060929,'YYYYMMDD'),'YYYY-MM-DD')

martin59 — Mon, 14 Jan 2013 14:04:28 GMT

Hi,

You have to use this expression in your LOAD script :

=Date(Date#(DATUM_AANVRAAG,'YYYYMMDD'),'YYYY-MM-DD')

Hope that helps you,

Martin Favier

CELAMBARASAN — Mon, 14 Jan 2013 14:08:00 GMT

Hi,

If you set a variable date format

SET DateFormat='YYYY-MM-DD';

Then you can smply use as

=Date(Date#(DATUM_AANVRAAG,'YYYYMMDD'))

Other wise

=Date(Date#(DATUM_AANVRAAG,'YYYYMMDD'),'YYYY-MM-DD')

Hope it helps

Mon, 14 Jan 2013 14:27:43 GMT

Got it working, thanks for the help!