Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

UNIX DATE to Qlikview DATE

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.
1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: UNIX DATE to Qlikview DATE

The formula is:

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

-Rob

http://masterssummit.com

http://robwunderlich.com

5 Replies
Partner
Partner

Re: UNIX DATE to Qlikview DATE

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

MVP & Luminary
MVP & Luminary

Re: UNIX DATE to Qlikview DATE

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

Hi,

maybe this thread helps:

Date settings

so one solution could be:

= Timestamp(25569 + EpochTimeField / 86400) 

hope this helps

regards

Marco

Not applicable

Re: UNIX DATE to Qlikview DATE

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?

Highlighted
Partner
Partner

Re: UNIX DATE to Qlikview DATE

It's division to convert seconds to days.