Convert qlikview date number (41662) to date

[#1]

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

[er_mohit · Accepted solution]

try only

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

hope it helps

[sujeetsingh]

Date() function will do as needed

[#4]

Thanks!

[maxgro]

you can also use 41662 in qvd and format in chart when you need a date using number tab