converting seconds into a date

[employe4_2]

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

[marcus_malinow · Accepted solution]

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

[jerryyang756 · Accepted solution]

=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 

[Giwa_Temitopoluwa]

how do I apply this?