Renewal dates being set to 2001 automatically when importing spreadsheets
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!
Vladimir Dubakin Posts: 95edited 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.