Convert Numeric to Date

[#1]

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

20070906

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

[MayilVahanan]

HI

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

[martin59 · Accepted solution]

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]

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

[#5]

Got it working, thanks for the help!