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

SOLVE
Occasional Contributor

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

Reply
0 Upvotes
1 Accepted solution

Accepted Solutions
Solution
Community Superstar

_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: HubSpot is a constantly evolving platform. Please check the date of each post and view all solutions in that context.

-- Visit

 

Hope that helps.

 

Be well,
Frank


Support • Web • Apps • Training

HubSpot's Hiring World-Wide!

View solution in original post

Reply
0 Upvotes
4 Replies 4
Solution
Community Superstar

_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: HubSpot is a constantly evolving platform. Please check the date of each post and view all solutions in that context.

-- Visit

 

Hope that helps.

 

Be well,
Frank


Support • Web • Apps • Training

HubSpot's Hiring World-Wide!

View solution in original post

Reply
0 Upvotes
Occasional Contributor

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.

Reply
0 Upvotes
Community Superstar

Did you resolve this @Achim?

 

Note: HubSpot is a constantly evolving platform. Please check the date of each post and view all solutions in that context.

-- Visit

 

Hope that helps.

 

Be well,
Frank


Support • Web • Apps • Training

HubSpot's Hiring World-Wide!

Reply
0 Upvotes
Regular Contributor

Same issue but figured out why.

 

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

 

date format.PNG

Reply
0 Upvotes