UNIX DATE to Qlikview DATE

[#1]

Hi everybody.

I have a field 'month' with this values

1388545200

1391223600

1393642800

1396321200

1398913200

1401591600

1404183600

1406862000

1409540400

There have UNIX format.

Do you know how i conver this to date in qlikview? I've been trying a few ways that i saw in the web but they didn't work.

Thank you

Greetings.

[jonasheisterkam]

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'))

[rwunderlich · Accepted solution]

The formula is:

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

-Rob

http://masterssummit.com

http://robwunderlich.com

[MarcoWedel]

Hi,

maybe this thread helps:

Date settings

so one solution could be:

= Timestamp(25569 + EpochTimeField / 86400) 

hope this helps

regards

Marco

[#5]

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?

[kuba_michalik]

It's division to convert seconds to days.