This content has been marked as final. Show 4 replies
I have a qlikview table MAX_INSERT_TIME where I have a column with qlikview dates.
Then I do
date(num#(MAX_INSERT_TIME), 'DD/MM/YYYY') as MAX_INSERT_TIME;
max(MAX_INSERT_TIME) as 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.