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.

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

seconde 1904 to date

Hi,

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) : 

=Timestamp(([SecondSince1970]/86400)+25569)

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
marcus_sommer
MVP & Luminary
MVP & Luminary

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

- Marcus