Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

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

- Marcus