Forum Discussion
date importing as negatives
Are both your server and your local computer share the same date format?
What number format are your dates being stored in within the source? For example are your dates stored as a whole number to represent "Days since 31/12/1899"? Its important to know exactly what the data looks like in its storage, not how it is displayed by a reporting layer.
Hi Anonymous, Both the server and the local machine are using the same date format.
Throughout the troubleshooting process, I've attempted to import as a VARCHAR, DATETIME and even tried converting to an INT format, VARCHAR allows the data to work and import, but converting to a DATETIME will break everything all over again, DATETIME does not work unless converted to a TEXT type after import and the int works as a sort order but will not work as a DATETIME. :)
Excellent recommendations though! :D