How are dates stored in HubSpot's backend


#1

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?


#2

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


#3

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