Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
employe4_2
New Contributor III

converting seconds into a date

Hi,

i got a second counter wich basicly is a date:  14 86 41 83 36 correspond to 6 february 2017 10:00:40

and 14 86 41 83 56 is 6 february 2017 10:01:00.

I would like to convert that big number into a date, but i can't found out how or if it's possible...

thx

 

2 Solutions

Accepted Solutions
marcus_malinow
Valued Contributor III

Re: converting seconds into a date

This looks like a Unix timestamp

See this thread for details on how to convert

https://community.qlik.com/t5/QlikView-Creating-Analytics/transform-UNIX-date-format-to-ASCII-Window...

pritamb89
Contributor

Re: converting seconds into a date

=Timestamp((1486418336/86400)+25569)

Output is here:

06/02/2017 09:58:56 PM

=Date(Timestamp((1486418336/86400)+25569),'DD/MM/YYYY')

Output:

06/02/2017 

2 Replies
marcus_malinow
Valued Contributor III

Re: converting seconds into a date

This looks like a Unix timestamp

See this thread for details on how to convert

https://community.qlik.com/t5/QlikView-Creating-Analytics/transform-UNIX-date-format-to-ASCII-Window...

pritamb89
Contributor

Re: converting seconds into a date

=Timestamp((1486418336/86400)+25569)

Output is here:

06/02/2017 09:58:56 PM

=Date(Timestamp((1486418336/86400)+25569),'DD/MM/YYYY')

Output:

06/02/2017