out-of-range datetime value

[NinaWilliam]

Hi there I wrote a web application and it was working fine with no errors in my local server and the live server. My system lost its data and the hard drive got corrupted. So my hard drive was replaced with a new one. When I configure the web application on my new hard drive and run it, it was working ok except for the part that is has date selection on it I get the following error Exception Type: System.Data.SqlClient.SqlException Exception Message: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Exception Source: .Net SqlClient Data Provider Exception Target Site: Read I didn’t change the code or anything; the same version is working on the live server with no issues. I don’t know why it is giving me this error in my machine. Any ideas??

[Abhijit Jana]

NinaWilliam wrote:

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

Problem is here. Did you check the stack Trace? Which part of your code throwing the error ? Have a look The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value

cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

[NinaWilliam]

I don't think that something is wrong with the code... because it is working on the other server.

[Abhijit Jana]

Did you gone through with this Thred

cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net View My Recent Article

[Sabari MD]

string Text; IFormatProvider provider = new System.Globalization.CultureInfo("en-CA", true); Text = GDate.Trim(); DateTime Dt = DateTime.Parse(Text, provider, System.Globalization.DateTimeStyles.NoCurrentDateDefault); return Dt.Date.ToShortDateString(); Try this code I thought this will help you

sabarimd

[NinaWilliam]

Thank you for your help... but I am still having the problem and I don't think there is somthing wrong with the code... I thing I ahve to fix it in my system settings but I don't know hoe to do that... Anyone can help me?

[NinaWilliam]

Hi guys ^_______^ I was able to fix the problem by replacing 102 to 103 in the following code line... SELECT Appointments.AppointDate WHERE (Appointments.AppointDate = CONVERT(DATETIME, '" & date1 & "', 103)) and it works fine now ^___^ Happy Programming :) :) :)