Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
maybe a unix date?
if yes see here
Re: UNIX DATE to Qlikview DATE
TimeStamp(Makedate(1970,1,1)+ 1425283213 /24/60/60)
Do you know what 1425283213 corresponds to date wise?
maybe a unix date?
if yes see here
Re: UNIX DATE to Qlikview DATE
TimeStamp(Makedate(1970,1,1)+ 1425283213 /24/60/60)
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
Yes that was the concept thanks