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.
Can I pull the Event Date through a HubSpot form in the correct format instead of just numbers?
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.
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).
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.