4 Replies Latest reply: Aug 1, 2014 6:22 AM by Massimo Grossi RSS

    Convert qlikview date number (41662) to date

      Hi there,

       

      I have a qlikview table MAX_INSERT_TIME where I have a column with qlikview dates.

       

      Then I do

       

      MAX_INSERT_TIME_FINAL:

      NoConcatenate LOAD

        date(num#(MAX_INSERT_TIME), 'DD/MM/YYYY')  as MAX_INSERT_TIME;

        LOAD

          max(MAX_INSERT_TIME) as MAX_INSERT_TIME

      RESIDENT MAX_INSERT_TIME;

       

       

      store MAX_INSERT_TIME_FINAL into max_insert_time.qvd (qvd);

       

      But I still have 41662 in my max_insert_time.qvd file.

       

      I would like to have it in DD/MM/YYYY format.

       

      Thank you