Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Super Contributor
Posts: 36
Registered: ‎01-11-2011
Accepted Solution

Data Provider cutting off dates

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?

Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Data Provider cutting off dates

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

RJ Samp
Copper Super Contributor
Posts: 36
Registered: ‎01-11-2011

Re: Data Provider cutting off dates

Thank You!

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