Friday, March 23, 2012

Saving date problem

I get the following error when I try to save a date:

When converting a string to DateTime, parse the string to take the date before putting each variable in the DateTime object.
I was using a calendar control thinking that might have been the problem so I am using just a text box for entry. In the ASP code for the Insert statement, I have this:

<asp:controlParameterName="InDate"Type="DateTime"ControlID="txtInDate"/>

I have double checked the SQL table to make sure that the field is DateTime and it is. Also, if I have not selected a date or the textbox contains no information then it does not error and just saves the field blank.

What do I need to do to store this date?
Thanks for the information.

It's missing the attribute PropertyName="Text" I believe.|||Nope, that wasn't it. And the calendar control does not have a "text" property so I changed it to PropertyName="SelectedDate" and then I still get the same error.

No comments:

Post a Comment