Renewal dates being set to 2001 automatically when importing spreadsheets

Dan May
Dan May Posts: 1
edited June 18 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 Ex-Pipedrivers Posts: 101
    Pipedrive Employee
    edited April 2021 #2

    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