kristiano
Posts: 6
|
Posted: 02/20/2009, 9:01 AM |
|
trying to save a record in a sql server 2005 database I get following error:
translated
ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]
During convert a char datatype to a datetime datatyp the range of datetime value is not valid.
Original
ERROR [22007] [Microsoft][ODBC SQL Server Driver][SQL Server]
Bei der Konvertierung eines char-Datentyps in einen datetime-Datentyp liegt der datetime-Wert außerhalb des gültigen Bereichs. ERROR [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Die Anweisung wurde beendet.
textbox dateformat dd.mm.yyyy
any idea?
|
|
|
geebee
Posts: 21
|
Posted: 02/21/2009, 1:29 AM |
|
Hi Kristiano,
I have seen a similar error message. To get past it, I am sure that once I set the format for the textbox, I then changed the textbox data type back to text and it worked fine.
Give it a try.
|
|
|
kristiano
Posts: 6
|
Posted: 02/21/2009, 5:35 AM |
|
Hi GeeBee,
that's it !
thank you
|
|
|
geebee
Posts: 21
|
Posted: 02/21/2009, 9:04 AM |
|
Glad you got it working.
This didn't happen in earlier versions.
|
|
|
|