Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

The formula is:

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

-Rob

http://masterssummit.com

http://robwunderlich.com

View solution in original post

5 Replies
jonasheisterkam
Partner - Creator III
Partner - Creator III

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
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Not applicable
Author

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
Partner - Specialist
Partner - Specialist

It's division to convert seconds to days.