updating date field in sql from form attached code not working

[melrse]

The form has a text box where the user will enter the date they have received a survey. The field type in sql I set up as a tiny date. Don't really care about time. When I try to submit, there are issues with converting from the form field to updating the file

Dim p As New SqlParameter("@ReturnedDate", Freturneddate.Text)

Above is the parameter for the date

<asp:TextBox ID="Freturneddate" runat="server" Style="border-right: blue thin solid;
border-top: blue thin solid; border-left: blue thin solid; border-bottom: blue thin solid"></asp:TextBox><br />

below is my text box.

Can you direct me as to how to make the text box compatable w/a type of date on sql?

The user needs to enter a date into text box. I do not care how they enter, I just need to be able to update that value to a date field in sql to be used for stats reporting.
Appreciate it.

 

[johnwm]

The 2 alternative robust ways:
1. Use a Javascript calendar control (forum216 or google)
2. Use separate dropdowns for day, month and year

It's always better to control the input tahn try to process the problems away afterwards

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints