Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Convert a number to date

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

1 Solution

Accepted Solutions
MVP
MVP

Re: Convert a number to date

maybe a unix date?

if yes see here

Re: UNIX DATE to Qlikview DATE

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

4 Replies

Re: Convert a number to date

Do you know what 1425283213 corresponds to date wise?

MVP
MVP

Re: Convert a number to date

maybe a unix date?

if yes see here

Re: UNIX DATE to Qlikview DATE

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

Not applicable

Re: Convert a number to date

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

Not applicable

Re: Convert a number to date

Yes that was the concept thanks