topic Re: Date format syncing with Airtable in Sales Integrations

Date format syncing with Airtable

NAds — Fri, 30 Jul 2021 07:28:12 GMT

Hello Hubspot experts. Help me out, will ya?

I am syncing Airtable with Hubspot through Zapier (all 3 are free versions).

All fields sync perfectly fine except the date fields from Hubspot. They dont translate to airtable.

What am i doing wrong?

Thanks in advance.

Re: Date format syncing with Airtable

MiaSrebrnjak — Fri, 30 Jul 2021 13:30:25 GMT

Hi @NAds,

Thank you for reaching out to the Community! Have you maybe considered using our Data Sync Integration with Airtable? Link here, it might be a suitable solution!

I also wanted to tag a couple of subject matter experts: @HubDoPete, @Ben_M, @ellenrathburn I've noticed that you shared great tips and solutions regarding Zapier in the past, do you maybe have any tips for @NAds?

Thank you!

Mia, Community Team

Re: Date format syncing with Airtable

Ben_M — Fri, 30 Jul 2021 17:19:55 GMT

What do you mean by "they don't translate"? Are you getting an error? From where (hubspot, zapier, airtable)? What is the error?

As mentioned, there is a native hubspot integration and I would always recommend native integrations over Zapier. But depending on what your error is, will depend on next steps for you.

Re: Date format syncing with Airtable

webdew — Sat, 31 Jul 2021 03:53:31 GMT

Hi @NAds ,

Frst you need to make sure that in both Hubspot and Airtable the property field type should be the same. If they are not the same, it won’t get copied.

Can you plz check which field type is selected for the property ‘Date’ in Airtable and let me know ?

So that i can help better.

Hope this helps!

If we were able to answer your query, kindly help the community by marking it as a solution.

Thanks and Regards.

Re: Date format syncing with Airtable

NAds — Sat, 31 Jul 2021 19:25:24 GMT

Hi Ben.
There is no "written" error. It just doesnt sync the hubspot date field with the airtable date field. I tried all date formats in airtable and 1 or 2 "work" but a random date is added. Not the correct one.

I believe the native hubspot integration is for paid hubspot plans only.

Re: Date format syncing with Airtable

NAds — Sat, 31 Jul 2021 19:27:17 GMT

Hello webdew.
It just doesnt sync the hubspot date field with the airtable date field. I tried all date formats in airtable and 1 or 2 "work" but a random date is added. Not the correct one.

Re: Date format syncing with Airtable

Ben_M — Sat, 31 Jul 2021 20:51:58 GMT

What types are working but posting the wrong date? Also if you have not already, have you involved airtable's support to see if this is potentially an issue on their end?

Re: Date format syncing with Airtable

NAds — Sun, 01 Aug 2021 17:20:52 GMT

So, these are two date fields in airtable.

- Formated both dates as Local and none synced.

- Both as friendly and only One of them synced (with the wrong date).

- US and nothing.

- European only synced the other field (wrong date and hour).

- ISO synced nothing.

I hope i wasnt too confusing.

Thanks in advance.

Re: Date format syncing with Airtable

HubDoPete — Thu, 05 Aug 2021 20:31:38 GMT

HubSpot API uses UNIX timestamps and Airtable API uses ISO 8601 format. You might not be able to achieve what you want with free Zapier if you need to add extra steps to the zap to reformat dates