Renewal dates being set to 2001 automatically when importing spreadsheets

Options
Dan May
Dan May Member Posts: 1
edited June 2022 in Sales CRM #1

I am having a couple of issues with importing spreadsheets from Excel. The biggest one being that it is taking my information about renewal dates and automatically change them to renewing in 2001. 

I have put the full date in on the excel side of things and I have also confirmed the format of the date during the import process too, but nothing seems to stop it taking me back in time.

 

Any ideas or help would be greatly appreciated!

 

Thanks,

 

Dan

Comments

  • Vladimir Dubakin
    Vladimir Dubakin Posts: 60
    First Comment Pipedrive Team
    edited April 2021 #2
    Options

    Hey, @Dan May !

    Thank you for the feedback. Hope you are having a good day otherwise.

    I am happy see that you have contacted the support in regards that issue already and found that adding date format  to the cells in excel helped with the data import.

     

    Kind regards,

    Vladimir