Data Provider cutting off dates

[mstrait]

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?

[RJSamp · Accepted solution]

You checked regional settings.....but did you check the Short Dates format? MM/DD/YYYY ???

[mstrait]

Thank You!

The format I had was "M/dd/yyyy". That was wrong. I changed it as suggested and it is working no.