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.

You can do it this way....


Dim myDate as Date = Date.parse(txtInDate.text)

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.
>