I’m trying to pull through a hubspot form with an Event Date, however i can’t seem to manage to pull the date through in the correct format. it just comes through with lots of numbers.
Page 1 / 1
Hi there
Welcome to the Community! 
The issue you're experiencing is because the HubSpot API endpoints use UNIX formatted timestamps in milliseconds, which is a bit different from the date formats we often see. But don't worry! We have a handy tool called the Formatter by Zapier that can help you out!
Formatter by Zapier is great at converting one date/time format into another. So, you can use one to change the UNIX timestamp into a format that suits your needs better. If you'd like to learn more about setting up this Formatter Step, you can check out this link: https://help.zapier.com/hc/en-us/articles/8496044811917-How-to-Get-Started-with-Formatter-by-Zapier#date-time-0-15
Here’s an example:
Hopefully, this helps! 
Thank you, I have install formatter but it doesn’t seem to be working. is there something I am doing wrong.
Hi
Try specifying the From Format.
I’ve tried that too and it still doesn’t seem to change :(
The Formatter expects a UNIX Timestamp like this with 10 digits.
The Event Date being provided is 13 characters.
Thirteen-character timestamps are generally UNIX timestamps with a millisecond precision.
You can add another Zap step to use a Formatter > Numbers > Perform Math Operation (divide by 1000).
Hi there,
Just checking in to see how you’re getting on with this. Were you able to get it sorted using a Formatter action as Troy suggested?
If you’re still in need of some help with this just let us know! 
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.