Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date conversion 42123 to number 201517

hi, while writing a incremental load, there turned up some problems with oracle and date formats.

the data is stored with dates like YYYYMM f.e. 201517

but when i get a date from a function in qlikview like today() or now() or date(today()-90,'YYYYMM'), it is stored as another date format (f.e. 42123 for 201517)

how can i convert the qlikview function output to something i can use while loading data ?

2 Replies
marcus_sommer

I'm not sure if 201517 is a (valid) date or YearMonth - try to get a correct one and anything else could be formatted like it would be needed - whereby by all matchings/calculations are pure numeric values like 42123 instead of 29.04.2015 better.

- Marcus

nagaiank
Specialist III
Specialist III

Try

=Num#(Date(42123,'YYYYMM'))