How to save date?

[Blue Sky]

I have a field which is used to store the date of birth of the user.
It looks like "__/__/___"(dd/mm/yyyy) in the form. I used masked edit to do that.

In the database I define the date of birth as type of datetime.
How can I save the date ?
i.e. rs("birthDate")=txtBirth ---> It doesn't work. Error generated

Thx

[d.paulson]

How about this.
rs("birthDate")= cdate(txtBirth)


David Paulson

[Blue Sky]

It doesn't work !!!
Error : Type Mismatch

[amzas]

try this :

rs!bdate=format(maskedit1.text,"mm/dd/yyyy")

[Blue Sky]

I've tried, but error generated : It said "Overflow " why?
How to solve this ?
Also , I would like to know how can I write a Insert statement for inserting a null date into the table ?