Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Convert Numeric to Date

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.

1 Solution

Accepted Solutions
martin59
Specialist II
Specialist II

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

View solution in original post

4 Replies
MayilVahanan

HI

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

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
martin59
Specialist II
Specialist II

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
Partner - Champion
Partner - Champion

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

Not applicable
Author

Got it working, thanks for the help!