Saving a date

[Brad]

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:controlParameter Name="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.

[neilphan]

You can do it this way....
Dim myDate as Date = Date.parse(txtInDate.text)

[Brad]

I have been working most of today trying to figure out this date problem
because that was in the error message, only to discover that is was NOT a
date problem, but another field that is set to type decimal had a control
parameter from a label (text). So what I did is to convert the text to
double, store it in a session variable and then set the parameter to the
session variable and voila!

"Brad" wrote:

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:controlParameter Name="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.