Hubspot date synch issues

[sbacookie]

Hello all

We are a SaaS company that has dedicated our supporting tech stack to Stripe and Intercom. However, I am having some real issues synching dates from Stripe and Intercom into Hubspot. 

For our sales, CRM, and support team it is important that we are able to synch date fields, but I cannot figure out how to successfully resolve this. 

Two examples are: 
1. Last seen date from Intercom. This can only be synched to HubSpot "close date". If I create a new custom field which is a date picker it will still not work. 
2. Created date from Stripe. This can only be synched to HubSpot "close date". If I create a new custom field which is a date picker it will still not work. 

Any suggestions for resolutions or workarounds? 

Thanks, 
Sebastian from Cookie Information

[jbogaert]

---

@sbacookie wrote:

Two examples are: 
1. Last seen date from Intercom. This can only be synched to HubSpot "close date". If I create a new custom field which is a date picker it will still not work. 
2. Created date from Stripe. This can only be synched to HubSpot "close date". If I create a new custom field which is a date picker it will still not work. 

Any suggestions for resolutions or workarounds? 

---

Hi @sbacookie,

Thanks for reaching out!

This is sadly a known issue when it comes to syncing Intercom and Stripe date fields. The date fields in Intercom or Stripe are actually date-time fields as opposed to HubSpot's fields, which contain just the date. Our team hasn't cracked the nut yet on how to cleanly convert date-time fields to simple date fields. That's why you're bumping into this limitation. For the moment, you'll only be able to sync Intercom or Stripe date fields to either text or numbers fields.

Data Sync by HubSpot uses the same sync engine as PieSync, which is why you're reporting a similar issue there: we can't sync Intercom datefields to datepicker fields, but we can convert datepicker fields to date-time fields. 

Hope this helps!

[sbacookie]

Hi! 

Unfortunately, through the new OperationsHub, I still cannot transfer Stripe or Intercom dates to text or numerical fields. When testing the only field available is "closed date". So this workaround is not relevant. 

Is there any other way to get the dates moved? 

[jbogaert]

---

@sbacookie wrote:

Is there any other way to get the dates moved? 

---

I am not in the ability to test this out, but you could maybe do the following:

1. Intercom Date Field > Data Sync > HubSpot custom (un)formatted number field
2. HubSpot custom (un)formatted number field > Workflow > HubSpot custom datepicker field

You might be able to use the 'copy property value' and 'format data' actions in HubSpot workflows to create a workflow that copies the raw intercom data to a HubSpot datepicker field and formats it correctly. I have not been able to confirm that this will work though.

If you're familiar with workflows please perform this workflow first on a limited set of contacts. If you're not that familiar please, reach out to customer support to make sure you've got it configured correctly.

 

[sbacookie]

Something has happened since yesterday because now the date fields from Intercom works fine with Hubspot date pickers. 
Meaning there is no issue with Intercom anymore. 

However, the stripe fields do not work with unformatted numbers. So the issue I cannot get the data from Stripe to Hubspot. 

[JWind]

Hi @sbacookie,

I'm in a similar situation, do you know what has been changed in order to map the Intercom date field with the Hubspot date fields?

Cheers,
Janick

[sbacookie]

Hi Janick

Unfortunately, I have still not been able to successfully synch dates from Stripe or Intercom into HubSpot. 

Best, 
Sebastian

[jbogaert · Accepted solution]

Hi @sbacookie,

In that case, I think it's better if you contact HubSpot's support team. They'll be able to look at the two fields you want to connect and see exactly why the system isn't able to map them with one another. If there is a fix or a workaround available, they'll be able to tell.

[sbacookie]

Also, if trying to use my existing PieSynch (which will be OperationsHub) I can only synch date fields one way; from Hubspot to X.