Help Centre Forum


Converting date in milliseconds from 1970 - In excel and other programming language

Author Yann D
21st March 2018
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

help can be found in the Connector 1.13 release video at

TOTECS Partner - Data Consultant