How are dates stored in HubSpot's backend

[meganvisser]

I'm in the process of creating a Zapier Zap to post messages in Slack and want to add a filter for dates.

The example deal from HubSpot, in Zapier, displays dates and timestamps as a set of numbers (i.e. 1530641714391).

Has anyone been able to get around this so you can filter on dates?

[meganvisser · Accepted solution]

Have worked it out, HubSpot stores dates in Unix format.
Zapier has a converter tool built in.

[cbarley]

Hi Megan, you're exactly right. We use unix timestamps in milliseconds.

developers.hubspot.com

How should timestamps be formatted for HubSpot's APIs?

HubSpot API endpoints accept UNIX formatted timestamps in milliseconds. Most scripting languages have built-in functions or existing libraries that handle time conversion, but you must ensure that your timestamp values are in the correct UNIX...