2 Replies Latest reply: Oct 29, 2015 12:05 PM by Nagaian Krishnamoorthy RSS

    Date conversion 42123 to number 201517

    Finn De Wit

      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 ?