About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • Can I pull the Event Date through a HubSpot form in the correct format instead of just numbers?
Question

Can I pull the Event Date through a HubSpot form in the correct format instead of just numbers?

  • 20 June 2023
  • 6 replies
  • 142 views
Splash Events

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.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

ken.a
Userlevel 7
Badge +6

Hi there @Splash Events,

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:

5089eafd9de03d2f3a6f598994dbfd17.png
(view larger)

0a56801d3c83326b9a5ab77d3b117bfb.png
(view larger)

Hopefully, this helps! 😊

 

 

 

Splash Events

Thank you, I have install formatter but it doesn’t seem to be working.   is there something I am doing wrong.

 

Troy Tessalone
Userlevel 7
Badge +14

Hi @Splash Events 

Try specifying the From Format.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Splash Events

I’ve tried that too and it still doesn’t seem to change :(

Troy Tessalone
Userlevel 7
Badge +14

@Splash Events 

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).

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
SamB
Rank
Userlevel 7
Badge +11

Hi there, @Splash Events!

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! 🙂

Terms & Conditions