Masked date textbox

[gayano]

Hi,

I'm using Visual studio 2005 pro Ver..]]]
I have a Form named form1
textbox named txtName
masked textbox (Date Masked) named txtMaskedDate
and a button to add data named btnAdd


dim name as string
dim startdate as date

when i click the button

name=txtName.te xt
startdate=txtMa skedDate.text

but the thing is the user may input a date or may not

so when i leave the date field empty I get a error message "Cannot convert string to a date" what should i do??

I want the user to have the choice of enter a date or not to enter a date

Thank you

[kenobewan]

Are they able to enter any date enter any date, e.g. 12/25/0033? Or could you just take today's date without having to ask? Doesn't sound like it - but you can use a calendar without the validation. This was a problem in a form I had a while ago. The problem is if you use a parameter in a stored procedure and you need to supply it a value. Outside a stored procedure:

Dim strSQL as string
Dim CNData as connection
set CNDATa= new connection
... Set connection properties to SQLServer
strSQL="Update tbl_A Set dtActivation = NULL Where fldkey=X"
CNData.execute strSQL

Or alternately if you pass "1/1/1900" to a stored procedure and then set
to NULL in the stored procedure. It all depends on where you want the
code to reside to do it.

[gayano]

Thank you
I try it when i go back to the office