Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
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
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

CELAMBARASAN
Partner
Partner

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!