Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

seconde 1904 to date


i got a second counter wich basicly is a date: and each seconde since 1904 1st january it's adding up

there is the solution for unix (seconds since 1970) : 


Output is here:

06/02/2017 09:58:56 PM

i don't understand how i convert the underlined parameter do it work for seconds 1904.

the divided by 86400 convert the seconds into days, but the 25569 ... i don't get it 

help thx


1 Reply
MVP & Luminary
MVP & Luminary

Just try: =Timestamp(([SecondSince1904]/86400)+1462)

- Marcus