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!