mfauzi
Posts: 14
|
Posted: 08/07/2008, 4:36 AM |
|
XP, Sql express, asp
I have a edit form. The record selected is from grid.
When I want to update the form, I got the following 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. (Microsoft OLE DB Provider for ODBC Drivers
Appreciate on any guide on how to update the date field
|
|
|
Benjamin Krajmalnik
|
Posted: 08/23/2008, 6:01 PM |
|
You need to make sure that the localization of the SQL server and that of
your CodeCharge app is the same.
If the dates are being passed d-m-y and the server expects m-d-y at some
point you will get this error.
"mfauzi" <mfauzi@forum.codecharge> wrote in message
news:6489ade3e844fb@news.codecharge.com...
> XP, Sql express, asp
> I have a edit form. The record selected is from grid.
> When I want to update the form, I got the following 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.
> (Microsoft OLE DB Provider for ODBC Drivers
>
>
> Appreciate on any guide on how to update the date field
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|