CRM

Achim
Participant

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

Hi,

 

the customer entered data and a date (birthdate, preferred delivery date) in a webform. This will be imported via ZAPIER Addin into HubSpot contacts.

Works.

But we noticed that the dates imported WRONG

e.g.

birthdate entered / Zapier logfile: 06.09.1972

birthdate HubSpot field: 08.06.1972

preferred delivery date entered / Zapier logfile: 05.09.2018

preferred delivery date HubSpot field:08.05.2018

 

Is this problem known by someone?

best regards

Achim

0 Votes
1 Solution acceptée
MFrankJohnson
Solution
Leader d'opinion

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: The customer entered data and a date (birthdate, preferred delivery date) in a webform. This was imported via ZAPIER Addin into HubSpot contacts. Works. But we noticed that the dates imported WRONG e.g.

 

birthdate entered / Zapier logfile: 06.09.1972

birthdate HubSpot field: 08.06.1972

preferred delivery date entered / Zapier logfile: 05.09.2018

preferred delivery date HubSpot field:08.05.2018

 

Is this problem known by someone??

 

Short A: Your date formats don't appear to match.

 

Longer A:

Without actually seeing your form, your Zap, AND your HubSpot portal we can safely say that the date formats appear to be different. Maybe in HubSpot they're set to mm.dd.yy, but set to dd.mm.yy on either your form or in Zappier.

 

In either case, date formats need to either be aligned in all platforms or their format differences identified and allowed for.

 

Always happy to help you build on HubSpot.

 

Best,
Frank


hubspot-solutions-signature-mfrankjohnson-v05.png

www.MFrankJohnson.com

Help find this post quickly ... accept this solution now.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com

Voir la solution dans l'envoi d'origine

0 Votes
4 Réponses
BLA
Contributeur

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

Same issue but figured out why.

 

The date format needs to be forced in excel see below.

 

date format.PNG

MFrankJohnson
Leader d'opinion

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

Did you resolve this @Achim?

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Votes
MFrankJohnson
Solution
Leader d'opinion

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

_hubspot-button-accept-as-solution-gif-v00.gif

 

Q: The customer entered data and a date (birthdate, preferred delivery date) in a webform. This was imported via ZAPIER Addin into HubSpot contacts. Works. But we noticed that the dates imported WRONG e.g.

 

birthdate entered / Zapier logfile: 06.09.1972

birthdate HubSpot field: 08.06.1972

preferred delivery date entered / Zapier logfile: 05.09.2018

preferred delivery date HubSpot field:08.05.2018

 

Is this problem known by someone??

 

Short A: Your date formats don't appear to match.

 

Longer A:

Without actually seeing your form, your Zap, AND your HubSpot portal we can safely say that the date formats appear to be different. Maybe in HubSpot they're set to mm.dd.yy, but set to dd.mm.yy on either your form or in Zappier.

 

In either case, date formats need to either be aligned in all platforms or their format differences identified and allowed for.

 

Always happy to help you build on HubSpot.

 

Best,
Frank


hubspot-solutions-signature-mfrankjohnson-v05.png

www.MFrankJohnson.com

Help find this post quickly ... accept this solution now.

 

Note: Please search for recent posts as HubSpot evolves to be the #1 CRM platform of choice world-wide.

 

Hope that helps.

 

Be well,
Frank


www.mfrankjohnson.com
0 Votes
GailH
Membre

Imported Date (birthdate, preferred delivery date) from Zapier changed / is wrong in HubSpot

Résolue

I'm having a similar problem when doing a deal import using an Excel spreadsheet.  The date format showing on my excel spreadsheet is dd/mm/yyyy and I am specifying that format in Hubspot. But when the import is complete either the date has reverted to mm/dd/yyyy or doesn't show at all.  

 

As far as I can tell all the date settings in Hubspot is in the correct format dd/mm/yyyy and I do think the problem originates in Excel - it appears to be changing the format back to mm/dd/yyyy on import.  

 

Any ideas how to resolve this.

0 Votes