topic Re: Convert a number to date in QlikView

Convert a number to date

Thu, 09 Jul 2015 16:48:40 GMT

Dear all,

I have a database with a field named as a date but I have only a 10 digit number (i.e:1425283213). I would like to use this as a data and obtain from it the day for the graphs.

Do you know how to convert this to a typical date DDMMYY?

I would like then used it to obtain weeks, months and years.

Regards

Javi

Re: Convert a number to date

sunny_talwar — Thu, 09 Jul 2015 16:50:54 GMT

Do you know what 1425283213 corresponds to date wise?

Re: Convert a number to date

maxgro — Thu, 09 Jul 2015 16:57:27 GMT

maybe a unix date?

if yes see here

Re: UNIX DATE to Qlikview DATE

TimeStamp(Makedate(1970,1,1)+ 1425283213 /24/60/60)

Re: Convert a number to date

Thu, 09 Jul 2015 17:02:30 GMT

In on of the project I worked, a column captures number of seconds elapsed since 1-Jan-1970. We used to convert that number to get the actual date by adding the number of days (1425283213/60/60/24) to the start date. Is this something similar in your case?

Regards,

KKR

Re: Convert a number to date

Thu, 09 Jul 2015 19:37:36 GMT

Yes that was the concept thanks