Skip to main content

Hi, I’m building an integration and I cannot see how to convert the activity_log.created_at field from an integer to a date. Cannot find anything in your KB, nor online in general.


An example of a returned “date” field is “15905438472681046”, which corresponds to approx May 28th 2020 (give or take a few days)


The number is too big to be Unix Epoch.


Thanks

Hey @benliebert – good question.


The date returned by the activity_logs field is Unix time to 17 digits of accuracy.


In Javascript, you can convert this to a date function by dividing it by 10,000 like so:

myDate = new Date(15905438472681046 / 10000)


Here’s what that looks like in the console:

Screen Shot 2020-06-15 at 2.52.30 PM


Hope that helps!

Perfect - thanks for your time.

oh wow… that was unexpected 😆

thanks for clarifying

Hey @kaminskypavel 👋


I’m glad @dipro could shed some light on this! That said, I truly appreciate you searching through the forum instead of creating a new topic about this - thanks so much 🙂


-Alex

Terms & ConditionsCookie settings