RADDateinput error

[L]

hi

I have a DateInput and i have the date format set to dd/MM/yyyy. I have also keyed in a date as 16/09/1970 and my table field DateOfBirth is of Date dataype in MSSQL.

But it just kept giving me this error "String was not recognized as a valid DateTime."

What is wrong? thanks

[Jose]

Hi L.

Could you paste the code here to check it out?

thanks.
Jose

[L]

hi

here is my code:

Sub methodA(byVal DOB as Date)

sqlcmd.Parameters.Add(New SqlParameter("@DOB", SqlDbType.Date)).Value = DOB
ExecuteNonQuery

End Sub

methodA(txtDOB.Text)


the txtDOB is a radDateInput and the DOB is a Date datatype in a table field. Thanks

[Jose]

Hi L.

Normally you would call something like:

methodA(txtDOB.SelectedDate.Value)

The reason is that the property "Text" will return the text representation of the date while SelectedDate will return the selected date as a nullable DateTime. Most likely you will also need to check wether txtDOB.SelectedDate.HasValue is true and return txtDOB.SelectedDate.Value.

Let me know if that helped. (and mark it as answer ;) )

Jose

[L]

hi Jose

thanks a lot. It is working fine now. Thanks