2. ASPRunnerPro General questions
  3. Datetime type resulted in an out-of-range value
This topic is locked

Datetime type resulted in an out-of-range value

 		11/9/2004 1:56:25 PM
ASPRunnerPro General questions
author

Hi there,
I am having a problem with Dates. Everywhere is ok but when I edit the record and save it again it shows this error

"[Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value."
I know about regional settings, I changed to different ways but it fails all the time.
When I list or view the record shows "29-10-2004" but when I edit it shows "10-29-2004" then when I save it does not like it. If I change it back to "29-10-2004" save button works fine.
When I list or view other record with "1-11-2004" (1-Nov-04) when I edit it shows "11-1-2004" then when I save it NO ERROR but change it to "11-1-2004" (11-Jan-04).
This is a terrible problem. Every time somebody edit a record either get an error or mess up the data.
HELP PLEASE

I use SQL Server 2000 and regional settings Spanish Chile in the ASPRunner and the computer. Also using asprunnerpro31a.exe 21-Oct-2004 14.16 2.1MB
Carlos
Sergey Kornilov admin 11/15/2004

Carlos,
please make sure your Web server regional settings are also set to Spanish Chile. It appears that ASP pages do not understand dd-mm-yyyy date format.
501108 11/26/2004

The Server is a shared service so we may not be able to do that, but Before it was working fiene with the same server. No changes at all on the server. Just the new version of ASPRunner...
Carlos
Sergey Kornilov admin 11/26/2004

Carlos,
just in case make sure that ASP code built with the previous version works fine on the same Web server.