topic Re: UNIX DATE to Qlikview DATE in QlikView

UNIX DATE to Qlikview DATE

Fri, 23 Jan 2015 20:38:43 GMT

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.

Re: UNIX DATE to Qlikview DATE

jonasheisterkam — Fri, 23 Jan 2015 20:48:10 GMT

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

Re: UNIX DATE to Qlikview DATE

rwunderlich — Fri, 23 Jan 2015 20:48:40 GMT

The formula is:

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

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: UNIX DATE to Qlikview DATE

MarcoWedel — Fri, 23 Jan 2015 23:49:34 GMT

Hi,

maybe this thread helps:

Date settings

so one solution could be:

= Timestamp(25569 + EpochTimeField / 86400)

hope this helps

regards

Marco

Re: UNIX DATE to Qlikview DATE

Mon, 26 Jan 2015 12:53:48 GMT

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?

Re: UNIX DATE to Qlikview DATE

kuba_michalik — Mon, 26 Jan 2015 12:56:56 GMT

It's division to convert seconds to days.