Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

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

Tags (1)
1 Solution

Accepted Solutions
er_mohit
Honored Contributor II

Re: Convert qlikview date number (41662) to date

try only

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

hope it helps

4 Replies
er_mohit
Honored Contributor II

Re: Convert qlikview date number (41662) to date

try only

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

hope it helps

sujeetsingh
Honored Contributor III

Re: Convert qlikview date number (41662) to date

Date() function will do as needed

Not applicable

Re: Convert qlikview date number (41662) to date

Thanks!

MVP
MVP

Re: Convert qlikview date number (41662) to date

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

Community Browser