Account & Settings

spino
Participant

modify import dates in the contacts

SOLVE

Good morning ....when i import file with this format day,for example 12/1/2022 in crm see 01/12/22...you know how to massively change dates?

0 Upvotes
2 Accepted solutions
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

You can change the date format in the setttings (Account defaults > User defaults > Date and number format), see here: https://knowledge.hubspot.com/account/change-your-language-and-region-settings#customize-default-use...

 

This will only affect how dates are displayed in HubSpot.

 

If you're importing a file with a date property, use the Date format dropdown menu to confirm how the date values in your spreadsheet are actually formatted and read.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

During the import process, there is an additional final step where HubSpot asks you to select the format of your date properties:

 

karstenkoehler_1-1642193324995.png

 

Could you please also share a screenshot of that?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

View solution in original post

0 Upvotes
15 Replies 15
spino
Participant

modify import dates in the contacts

SOLVE

 

spino_0-1642445189128.png

 

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE

this in hubspot change my date from excel and i can't modify

spino_0-1642073149818.png

this in excel 

spino_1-1642073244486.png

 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

During the import process, there is an additional final step where HubSpot asks you to select the format of your date properties:

 

karstenkoehler_0-1642073874481.png

 

 

Could you please also share a screenshot of that?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

spino
Participant

modify import dates in the contacts

SOLVE

I tried to load the contacts but I don't get the choice on the date format you put above, it just loads them...

spino_0-1642421056852.png

 

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

That's weird. For the unlikely scenario that this has simply not yet been translated into English, would you mind changing your account language to English and trying again?

 

Best regards!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE

 i try change language but doesn't work different...with free version i don't have that menu that you tell me

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

Can you please share:

  • a screenshot of the date column in your spreadsheet
  • a screenshot of the step during the import process where you are asked to select the date format (date format dropdown)

I would need this to further investigate.

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

spino
Participant

modify import dates in the contacts

SOLVE

thanks for the help

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE

Hi Kristen When i import the contacts its all right but a dates change format…my impostation is correct but the system transformer my date 13/1/22 to 1/13/22 anyway.thanks for the help

spino_0-1642071985030.png

 

 

0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

You can change the date format in the setttings (Account defaults > User defaults > Date and number format), see here: https://knowledge.hubspot.com/account/change-your-language-and-region-settings#customize-default-use...

 

This will only affect how dates are displayed in HubSpot.

 

If you're importing a file with a date property, use the Date format dropdown menu to confirm how the date values in your spreadsheet are actually formatted and read.

 

Hope this helps!

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE
When i import the contacts its all right but a dates change format.my
impostation is correct but the system transformer my date 13/1/22 to 1/13/22
anyway


0 Upvotes
karstenkoehler
Solution
Hall of Famer | Partner
Hall of Famer | Partner

modify import dates in the contacts

SOLVE

Hi @spino,

 

During the import process, there is an additional final step where HubSpot asks you to select the format of your date properties:

 

karstenkoehler_1-1642193324995.png

 

Could you please also share a screenshot of that?

 

Best regards

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE

hi karstenkoehler i don't have it in the process...i try with a new excel file just with dates 

spino_0-1643616131964.png

 

But when i import file change my impostations 

spino_1-1643616193337.png

i modify my profile but nothing... 

spino_2-1643616330666.pngspino_3-1643616384517.png

 

0 Upvotes
spino
Participant

modify import dates in the contacts

SOLVE

maybe i find the problem....if i change in excel data format in english hub spot import dates correct

 

 

0 Upvotes
ASmith76
Member

modify import dates in the contacts

SOLVE

I had a similar problem and I found that in Firmao dont exist this issue

0 Upvotes