Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try only
date(MAX_INSERT_TIME) as MAX_INSERT_TIME instead of date(num#(MAX_INSERT_TIME), 'DD/MM/YYYY')
hope it helps
try only
date(MAX_INSERT_TIME) as MAX_INSERT_TIME instead of date(num#(MAX_INSERT_TIME), 'DD/MM/YYYY')
hope it helps
Date() function will do as needed
Thanks!
you can also use 41662 in qvd and format in chart when you need a date using number tab