Skip to main content

Dashboard Export displaying the TimeStamp as numbers.

Written by Ian Maison

Dashboard Export displaying the TimeStamp as numbers.
eg: 637971121550765000
​
This is due to the Microsoft Azure timestamp convention from the database, Navori is able to translate the tick data into readable timestamp from the CMS.
​
The time is displayed in ticks based on milliseconds, Please use the following Tick URL to translate the data:

https://tickstodatetime.azurewebsites.net/ - enter 637971121550765000 into the conversion and the timestamp will appear.
​
Further information about the ticks from Azure - https://docs.microsoft.com/en-us/dotnet/api/system.datetime.ticks?view=net-6.0

We have requested additional R&D in terms of translating the data directly within the excel export.

Did this answer your question?