# modify import dates in the contacts **URL:** \ **Category:** Account & Settings\ **Tags:** free\ **Created:** [January 12, 2022, 11:57am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642 "2022-01-12T11:57:16Z")\ **Posts on this page:** 16\ **Page:** 1
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 12, 2022, 11:57am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/1 "2022-01-12T11:57:16Z")
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? ---
**Author:** ![ASmith76](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@ASmith76](https://community.hubspot.com/u/ASmith76)\ **Post date:** [January 12, 2022, 11:59am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/2 "2022-01-12T11:59:23Z")
I had a similar problem and I found that in Firmao dont exist this issue ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 12, 2022, 12:12pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/3 "2022-01-12T12:12:35Z")
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-user-language-date-and-number-format](https://knowledge.hubspot.com/account/change-your-language-and-region-settings#customize-default-user-language-date-and-number-format) 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! ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 14, 2022, 7:21pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/4 "2022-01-14T19:21:21Z")
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 ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 14, 2022, 8:48pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/5 "2022-01-14T20:48:58Z")
Hi @spino, During the import process, there is an additional final step where HubSpot asks you to select the format of your date properties: ![57403i9F483580B54C9F39.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/2/e2a410c2675ef89b1aba8b114d5644282c001923.png) Could you please also share a screenshot of that? Best regards ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 31, 2022, 8:06am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/6 "2022-01-31T08:06:34Z")
hi karstenkoehler i don’t have it in the process…i try with a new excel file just with dates ![spino_0-1643616131964.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/e/e41faa7c9831d545db4f0f3f6c0abe4a7d156423.png) But when i import file change my impostations ![spino_1-1643616193337.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/4/24f8e56e2639922bb333ed5850dd133d2596ba98.png) i modify my profile but nothing… ![spino_2-1643616330666.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/4/642a6ca6b2f86ba3646100655ed812bd4a364882.png) ![spino_3-1643616384517.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/c/7c3c4325e0eb929a98227baa980c78dc8aaff3bb.png) ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 31, 2022, 8:16am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/7 "2022-01-31T08:16:44Z")
maybe i find the problem…if i change in excel data format in english hub spot import dates correct ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 13, 2022, 11:06am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/8 "2022-01-13T11:06:41Z")
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](https://d2qpr2jzcazej7.cloudfront.net/original/3X/b/9/b9e7d3eab5348fc92250ed0ba248e3d65268c96e.png) ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 13, 2022, 11:07am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/9 "2022-01-13T11:07:39Z")
thanks for the help ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 13, 2022, 11:09am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/10 "2022-01-13T11:09:45Z")
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 ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 13, 2022, 11:29am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/11 "2022-01-13T11:29:04Z")
this in hubspot change my date from excel and i can’t modify ![spino_0-1642073149818.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/6/3/63569137d3c9e0b89a6a536296d745a3bd515c82.png) this in excel ![spino_1-1642073244486.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/2/6/2646b00966a55a4c265db97c207e18a3478c2a64.png) ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 13, 2022, 11:38am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/12 "2022-01-13T11:38:10Z")
Hi @spino, During the import process, there is an additional final step where HubSpot asks you to select the format of your date properties: ![](https://d2qpr2jzcazej7.cloudfront.net/original/3X/d/f/df710b612772df7ca43a46befc736355c1573d6f.png) Could you please also share a screenshot of that? Best regards ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 17, 2022, 12:04pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/13 "2022-01-17T12:04:28Z")
I tried to load the contacts but I don’t get the choice on the date format you put above, it just loads them… ![57484iCF35D7E6F25D0243.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/7/c/7c8957f263d5823e1e8e5d6f518ece8eaa42225e.png) ---
**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\ **Post date:** [January 17, 2022, 12:11pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/14 "2022-01-17T12:11:12Z")
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! ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 18, 2022, 11:40am UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/15 "2022-01-18T11:40:19Z")
i try change language but doesn’t work different…with free version i don’t have that menu that you tell me ---
**Author:** ![spino](https://avatars.discourse-cdn.com/v4/letter/s/a4c791/32.png) [@spino](https://community.hubspot.com/u/spino)\ **Post date:** [January 17, 2022, 6:46pm UTC](https://community.hubspot.com/t/modify-import-dates-in-the-contacts/49642/16 "2022-01-17T18:46:43Z")
![spino_0-1642445189128.png](https://d2qpr2jzcazej7.cloudfront.net/original/3X/e/b/eb1344e41cc1f1e10ec18202d330ef420dbcfc17.png)