The conversion of a varchar data type to a datetime data typ

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

The statement has been terminated

 

how to solve this problem.please anyone solve this problem.below this code:

 

 form aspx:

From Date

EditFormatString="dd/MM/yyyy" CssClass="form-control select">

<%-- --%>

To Date

EditFormatString="dd/MM/yyyy" CssClass="form-control select">

<%-- --%>

 

 

 

 

 

public static string SetDate(string date)

{

string setdate = null;

if (date != null && date != "")

{

DateTime dt = DateTime.ParseExact(date, "d/M/yyyy", CultureInfo.InvariantCulture);

// for both "1/1/2000" or "25/1/2000" formats

setdate = dt.ToString("dd/MM/yyyy");

//DateTime date1 = Convert.ToDateTime(date);

//var date2 = date1.Date;

//var D = date2.Day;

//var M = date2.Month;

//var y = date2.Year;

//string monthStr = M.ToString("00");

//setdate = D.ToString() + "/" + monthStr.ToString() + "/" + y.ToString();

}

//if (date != null && date != "")

// setdate = DateTime.Parse(date).ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);

return setdate;

}

 

 

sanjida