String was not recognized as a valid DateTime from DateTimePicker

Question

I get his error at hnddate(hidden field value coming from date time picker):

String was not recognized as a valid DateTime.when converting a string to datetime parse the string to take the date before putting each variable

DateTime weekStartDate = GetFirstDayOfWeek(Convert.ToDateTime(hdndate.Value))
                                          .AddDays(0);
DateTime weekEndDate = weekStartDate.AddDays(14);

the query gets the startdate by comparing to a column in datatabse which is in 2014/04/28 and the datepicker (hnddate) has 28/04/2014 format.

the query gets the startdate by comparing to a column in datatabse which is in 2014/04/28 and the datepicker (hnddate) has 28/04/2014 format. — user2525244, Apr 28 '14 at 20:50
`Convert.ToDateTime()` takes a string, but a datepicker's `Value` is already a DateTime object, not a string. — Claies, Apr 28 '14 at 20:52

score 1 · Accepted Answer · answered Apr 28 '14 at 21:00

Assuming hdndate.Value is actually a string and its value is "28/04/2014":

Replace this:

Convert.ToDateTime(hdndate.Value)

With this:

DateTime.ParseExact(hdndate.Value, "dd/MM/yyyy", CultureInfo.InvariantCulture);

DateTime.ParseExact allows you to specify the exact format of your input string, so that it can correctly generate a DateTime from it. In this case, your format is dd/MM/yyyy.

String was not recognized as a valid DateTime from DateTimePicker

1 Answers1