Discussion board where members can get started with QlikView.
I have a field 'month' with this values
Go to Solution.
The formula is:
TimeStamp(Makedate(1970,1,1)+ unixtime /24/60/60)
Seconds since 1970:= Unixtimestamp, the QlikView timestamp has 1.0 = 1 Day. So it is Unixtime/24(h)/60(min)/60/(sec) now it is the same base now add the offset and ready.
maybe this thread helps:
so one solution could be:
= Timestamp(25569 + EpochTimeField / 86400)
hope this helps
Thank you, i have one doubt.
what is unixtime /24/60/60 ??
unixtime = my date
and /24/60/60 ? is that a format or a division?
It's division to convert seconds to days.