Inversion Key

Month Day Inversion On DataLoad

Good Day,

I am currently trying to recitify an issue where my DateCreated field is being inverted for the first 12 days of the month. The date format is being passed in as MM/DD/YYYY and for some reason the dataload is inverting to DD/MM/YYYY.

This of course is one issue, my second issue is that I am trying update the current incorrect data. Thankfully I have a TimeCreated field for the actual record transaction time. which is stored as a varchar(30). The following query is kicking out an error though.

SELECT DateCreated, AgentName, ProductType, TransactionType, AccountNumber, CustomerName, CustomerPhone, CustomerDOB, Language, TimeCreated,
AgentID, SaleType
FROM tbl_TMP
WHERE (CONVERT(DateTime, CONVERT(Char(10), DateCreated, 101)) <> CONVERT(DateTime, CONVERT(CHAR(10), TimeCreated, 101)))

This query returns a number of records but not all and kicks back an error message as follows;

"Conversion failed when converting datetime from character string."


Any suggestions on the second issue, and for that matter why the heck is issue one occuring?