Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody.
I have a field 'month' with this values
1388545200
1391223600
1393642800
1396321200
1398913200
1401591600
1404183600
1406862000
1409540400
The formula is:
TimeStamp(Makedate(1970,1,1)+ unixtime /24/60/60)
-Rob
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.
=timestamp(1388545200/24/60/60+date#('1.1.1970','D.M.YYYY'))
The formula is:
TimeStamp(Makedate(1970,1,1)+ unixtime /24/60/60)
-Rob
Hi,
maybe this thread helps:
so one solution could be:
= Timestamp(25569 + EpochTimeField / 86400)
hope this helps
regards
Marco
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.