Convert a number to date

[#1]

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

[sunny_talwar]

Do you know what 1425283213 corresponds to date wise?

[maxgro · Accepted solution]

maybe a unix date?

if yes see here

Re: UNIX DATE to Qlikview DATE

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

[#4]

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

[#5]

Yes that was the concept thanks