Last post Jul 31, 2008 04:04 AM by Zong-Qing Li - MSFT
Jul 27, 2008 07:12 PM|Kannandesikan|LINK
i try to enter manually the date in the database my field type is datetime but it throws the error
error conversion of a char datatype to a datetime datatype resulted in an out-of-range datetime value
please guide i want to enter the date manually its very urgent
Jul 27, 2008 07:57 PM|HeartattacK|LINK
Your database collation is set to use another culture. So, if you're typing:
22/4/2008 and you get an error, try typing 4/22/2008. If you still have an error, please post exactly what you typed and I'll be able to help.
Also, please don't make requests stating your query is very urgent. Some very senior forum members get very annoyed by this. We try to help anyone and everyone, and saying it's urgent has little to no impact.
Jul 28, 2008 04:00 AM|Kannandesikan|LINK
i am using datetime field in the database iam using vb.net 2005 i got the same error
i got the same error the converstion of a char data type to a dattime datatype resulted in an out-of-range datetime value the statement
has been terminated souce.
Jul 28, 2008 05:57 AM|ROAMER|LINK
Can you please post your SQL statement here?
Jul 31, 2008 04:04 AM|Zong-Qing Li - MSFT|LINK
As far as I can see, I suggest to use Calendar control for the users to select the date or use the CompareValidator control to confirm the date which the users typed is valid.
Please refer to the following link below for the information about "Calendar control" and "CompareValidator control ".
If I misunderstood the issue, please inform of me.