12-09-2011 10:04 AM
I just installed SLX on a test server to test an upgrade. I am getting the error "The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value." The relevant parf of the SQL statement is "... and History.CompletedDate > '12/1/2011'" The SLX data provider turns that into:
and ((History.CompletedDate > '12/1/2011' and Timeless = 'F') OR History.CompletedDate > '12/1/201 00:00:00' and Timeless = 'T'))
Notice that the year in the second half is only 3 digits. If I add an 'and less than another date' clause, the year is cut down to the first two digits (i.e. 2011 becomes 20).
I have already checked the regional settings and they are set to US on both the SLX and SQL servers.
Any ideas why the data provider would mess up the dates?
Solved! Go to Solution.
12-10-2011 05:14 PM
You checked regional settings.....but did you check the Short Dates format? MM/DD/YYYY ???
12-14-2011 02:37 PM
Thank You!
The format I had was "M/dd/yyyy". That was wrong. I changed it as suggested and it is working no.