TOTECS Forums

Converting date in milliseconds from 1970 - In excel and other programming language
Author
Thread
Converting date in milliseconds from 1970 - In excel and other programming language
Author Yann D
March 21 2018 @ 10:08 AM
Thread In the maker model export, the released date and the created date are in the form of a number of milliseconds since the 01-01-1970 12:00am Epoch in UTC time-zone.

In order to convert in excel a date format YYYY to a UNiX epoch number of millisecond for all model,
I have used the following formula:

epochdate = (DateValue(YYYY) - 25569) * 86400 * 1000

Note: This formula also works for model with date prior to 1970.

You can also found help to perform this conversion in different programming language using the following website
https://currentmillis.com/

Further
help can be found in the Connector 1.13 release video at https://youtu.be/PQ6osVe57uw


TOTECS Partner - Data Consultant

Post a Comment
Message:
By clicking on the Post button you accept the rules and guidelines of using this forum.