topic Convert qlikview date number (41662) to date in QlikView

Convert qlikview date number (41662) to date

Fri, 01 Aug 2014 10:16:00 GMT

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 — Fri, 01 Aug 2014 10:19:18 GMT

try only

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

hope it helps

sujeetsingh — Fri, 01 Aug 2014 10:20:53 GMT

Date() function will do as needed

Fri, 01 Aug 2014 10:22:08 GMT

Thanks!

maxgro — Fri, 01 Aug 2014 10:22:10 GMT

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