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.
"If I can see further than anyone else, it is only because I am standing on the shoulders of giants."blog: www.heartysoft.com twitter: @ashic
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.
<div class=ForumPostSignature>Sincerely,
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question. </div>
Sincerely,
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.
Kannandesika...
Member
368 Points
764 Posts
error conversion of a char data type to a datetime datatype resulted in an out-of-range datetime ...
Jul 27, 2008 06:12 PM|LINK
Hi,
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
Kannandesikan
HeartattacK
All-Star
55262 Points
5917 Posts
Moderator
MVP
Re: error conversion of a char data type to a datetime datatype resulted in an out-of-range datet...
Jul 27, 2008 06:57 PM|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.
blog: www.heartysoft.com
twitter: @ashic
Kannandesika...
Member
368 Points
764 Posts
Re: error conversion of a char data type to a datetime datatype resulted in an out-of-range datet...
Jul 28, 2008 03:00 AM|LINK
Hi,
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.
Kannandesikan
ROAMER
Participant
1367 Points
258 Posts
Re: error conversion of a char data type to a datetime datatype resulted in an out-of-range datet...
Jul 28, 2008 04:57 AM|LINK
Can you please post your SQL statement here?
if (myReply.Equals(YourAnswer))
{
MarkThisThread = "Answerd";
}
Zong-Qing Li...
All-Star
26878 Points
2165 Posts
Re: error conversion of a char data type to a datetime datatype resulted in an out-of-range datet...
Jul 31, 2008 03:04 AM|LINK
Hi,
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 ".
http://www.asp.net/AJAX/AjaxControlToolkit/Samples/Calendar/Calendar.aspx
http://msdn.microsoft.com/en-us/library/cc295090.aspx
If I misunderstood the issue, please inform of me.
<div class=ForumPostSignature>Sincerely,Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question. </div>
Zong-Qing Li
Microsoft Online Community Support
Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as
Answer” if a marked post does not actually answer your question.