Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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

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

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.